Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

So, let’s say you’re looking at a three-page setup: you've got your cover page, then the table of contents, and finally the introduction. If I'm following your logic correctly—and I try my best to keep up here—you actually want that third page, the intro, to be labeled as page "2." It sounds counterintuitive, I know, but if that's the goal, here is how you handle it in Word 2007: First, go to the very end of that first page (the cover), hit Insert, select Break, click Next page, and then just hit OK. Once you're sitting on that second page (your contents), head over to Insert, then Page Numbers. Make sure you uncheck the box for Show Number on First page. Then, go into Format, set the starting number to 1, and hit OK, OK. That should force the system to display the number "2" right there on your third sheet, the Introduction.

velvetdrifter15 said:Basically, I need to get some page numbers going on a paper in Word

Got the text breakdown from @Walter Jackson48/">@@Walter Jackson48, plus here's the visual stuff

- How to start numbering from a specific page in Word 2003

- How to start numbering from a specific page in Word 2007

John Cooper65 said:Any help would be huge. Seriously.

Here's a little something to help you out while you study. 😉

Just use the function. Average.
Using the function... IF
Just use the Sort command in Excel. Simple.
Just use the function. SUM
Just use the function. MAX
Just use the function. I'm still waiting on that info. What's the deal?

=A7^2 (=POWER(A7,2))
=A7^3 (=POWER(A7,3))
=POWER(A7, 1/3)
Just a quick tip: if you want that result, go with =-1000/A7. Simple as that.
=3.14*A7
=(3.14*(A7^2))/4
- Just `=SQRT(A7)`. Simple enough.

I am encountering difficulties when attempting to link tables in Access, specifically regarding the setup of Enforce Referential Integrity.

The core issue is my lack of clarity regarding the specific requirements necessary to successfully establish Integrity.

I am repeatedly receiving the following error message: "no unique index found for the reference field of the primary table."

Does anyone have insight into what might be causing this error?

Olivia Booth27 said:I'm struggling to link my tables in Access—specifically when trying to set up Enforce Referential Integrity.

The real headache is I have no clue which specific conditions need to be met to actually achieve Integrity.

I keep getting hit with this error: "no unique index found for the reference field of the primary table."

Does anyone actually know what's causing this?

You probably don't have a primary key set up to link those tables. Either create one yourself or just let Access handle it automatically... Honestly, that’s usually where the breakdown happens.

I need to know if there’s a workaround for this:

When I convert a field into a combo box—basically creating a dropdown menu populated by a specific table or query—is it actually possible to pull data from multiple different tables at once?

Here is the setup:

Say I have one table for walls with their IDs, another for beams with their IDs, and a third for columns with their IDs.

I want to build a single combo box in my form that lets me select an ID from any of those three separate tables.

Does anyone know how I can delete this note?

It's that shorter, darker line right here.

On my work computer, I'm running the 64-bit version of Windows 7 with Office 2007 installed. For some reason, the cut command in Excel isn't working properly. It essentially acts just like a copy command instead.

Specifically, after I highlight the cells I want and select cut (whether I use the ribbon, the keyboard shortcut—ctrl+x—or the right-click context menu), the selected cells flicker for a split second and then return to their "normal" state.
At that point, if I try to paste them into the destination, they will paste correctly, but they remain in the original location as well; effectively, it performs a copy rather than a move.

Additionally, the "insert cut cells" option is completely unavailable to me. This feature is actually quite vital for my workflow because I frequently pull data from an online system and then have to manually reorganize everything.

I've also noticed that copying non-contiguous ranges is broken. If I select multiple fields within the same column by holding down the CTRL key, when I go to paste those selected fields elsewhere, it copies all the cells in between the selections too.

Back at home, I've been using Excel 2007 on a 32-bit version of Windows 7 for two years now, and
everything there works perfectly without any issues.

Has anyone else dealt with something similar? Does anyone have an idea what might be causing this? Furthermore, do you think a full reinstallation of Office could potentially resolve the issue?

Question

How do I input a SUMIF formula when the criteria range and the sum range are located in a different Excel file across multiple sheets?

🙂

I've got two columns filled with numbers.

I need the third column to show the difference between the first two, and the fourth one to show that difference as a percentage. I’m clearly struggling here because I can't seem to find these basic functions—everyone else seems to be using the complex stuff, but I just need the basics.

Need some help ASAP!

casualbear7 said:Make that line shorter and darker.

First thing you gotta do? Go into the AutoCorrect dialog box and just kill that setting. Turn it off. Hyphens.

If you want another way to deal with this mess and just wipe those existing lines out, try doing this instead.
Just select the whole thing in the doc, then hit that tab. Border and Shading Go to the Borders tab and just pick the first option—the one with zero lines. Check this link for help with Border and Shading; you’ll want to clear out that bottom line in the preview field. Or just take a look at this. here

well, you don't really need a specific addition or subtraction function since you've already got (+) and (-)..

Angela Smith14 said:On my work computer, I am running the 64-bit version of Windows 7 with Office 2007 installed. For some reason, the cut command in Excel isn't working properly. It basically acts just like a copy command instead.

After I select the cells I want and choose Cut (whether I use the menu, the keyboard shortcut Ctrl+X, or the right-click context menu), the selected cells flicker for a split second and then return to their "normal" state.
When I try to paste them into the destination, they do paste correctly, but the original cells remain in their starting position—meaning it performs a copy rather than a move.

Furthermore, I can't use the "Insert Cut Cells" option, which is quite essential for me since I pull data from an online system and then have to manually reorganize things.

I also noticed that copying non-contiguous ranges doesn't work right either; if I select multiple cells in the same column by holding down the CTRL key, when I paste them elsewhere, it copies all the cells in between my selections as well.

At home, I've been using Excel 2007 on a 32-bit version of Windows 7 for two years now, and
everything works perfectly there.

Has anyone else experienced this, or does anyone know what might be causing it? Do you think reinstalling Office might help?

I actually found the solution to this problem, so I wanted to share it here in case anyone else gets stuck on the same issue.
The culprit was the Skype's Click-to-call installation. Once I uninstalled it, everything returned to normal. Apparently, updating that specific software is supposed to fix the conflict, but since I don't even use it, I won't bother reinstalling the latest version that is meant to run without clashing with Office.

Does anyone happen to know how to take one larger PDF and split it into two smaller ones? I mean, is it actually possible to just cut that PDF into two separate pieces?

Ryan Hayes82 said:Does anyone know how to take one large PDF and turn it into two smaller ones? Basically, can I just split this PDF into two separate parts?

Look, this isn't really what this thread is about, but here's my two cents. Just type pdf split online free into Google and see what pops up. Honestly, just find the tool that works best for you—specifically, look for one that doesn't demand your email address just to function. You want something where you upload the file, get it processed, and download it immediately without all the extra nonsense!!!

Hey guys, does anyone know how to get rid of those annoying red squiggly lines that pop up while you're typing? I know they won't show up on the hard copy, but I need them gone because I'm sending out my resume and I need everything to look flawless.

Later

select the whole text -> review -> language -> set proofing language -> then just pick English or whatever language you're using for your resume or whatever...

Larry Johnson5 said:I'm being quiet. Clearly I can't find the basic stuff. There’s plenty of the complex functions, though—it’s like they’re everywhere.

You're not "clueless," you're just too lazy to Google it. 😉

Just some number, like: 412
B1: some number, like: 85
Just use the function. Subtraction. Just a basic subtraction formula. Simple enough.
D1: for the math percentage Just use the formula =C1/A1 and then set the cell formatting to... Percentages.

Hey there
I need some help with a LOOKUP function.
I built this formula using nested IF statements, but I'm trying to switch over to LOOKUP—only it keeps throwing an error because of those hyphens.

This works fine:
Code:

But this one doesn't🙂
Code:

If anyone knows how to fix this, let me know.
Thanks

Hi there!
I picked up an Office 2007 disc in American—even though I already have the English version installed—and tried to run the setup. It started off fine; it asked for my product key, which I entered without issue, but then everything just stalled halfway through. A window popped up asking me to select an installation path (showing my C: drive, D: drive, etc.), but no matter what I clicked, it wouldn't let me select a valid location... quite frustrating, really. Could this be happening because I haven't uninstalled the English version of Word yet? Or am I looking at a faulty disc or perhaps some weird glitch with my PC? Thanks for any help!