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

and there’s really no point if those other guys are just gonna hit print anyway😕

edit: okay, finally cracked it. I just grabbed the whole chunk of text, dumped it into a fresh Microsoft Office doc, and boom—everything looks perfect on the new one. Honestly, don't even ask. I have no clue why it was acting up like that, just one of those weird, annoying glitches

Hope you got that figured out 🙂

Alright, I'm running into an issue with columns. I want to set up a left column on just one specific page, but every time I try, it applies the formatting to the entire document. I attempted to tweak the settings by unchecking "Apply to whole document" and selecting "Apply to this section," but it still forces the layout onto that page and everything following it. I even tried "Apply to this point forward," and I'm getting the exact same result. How do I isolate columns to a single page? I know there's a way to do this, but I can't figure out the trick. I'm using Microsoft Office 2010.

I want my text on one page to look like this:

Adam Watson3 said:How do I apply a column to just one sheet? I know there's a way to do it, but how?

Excel is your only real option. hidden boundaries Just post it. Breakthrough. Before and after the column.

Hello,
I find myself in a bit of a technical predicament regarding Microsoft Office. I am currently working within Word 2007, and I have constructed a rather specific layout where I've pasted and organized some text inside a text box. My intention is to add a caption to this particular element, much like one would do when labeling an image or a table—a process which, fortunately, works quite seamlessly for those other objects. However, when I attempt to apply a caption to the text box itself, the standard method seems to elude me. Does anyone happen to know the proper procedure for adding a caption to a text box in this version of the software?

Quote:.

Ivan C says: Your other options are using tables with hidden borders or adding a break before and after the columns

Thanks, man. You really helped me out here.🙂.

Rachel Hill23 said:you should probably add a caption for the Text Box.

Try converting the Text Box into a Frame

I managed to complete the conversion; I actually pulled it off! 😁Thank you so much!

Hey there!

I’m looking for some guidance on how to set up a formula so that at the end of an existing row, it automatically calculates the total hours and minutes worked for that month.
Since this is an established document, I'm a bit hesitant to mess with the structure too much—it's one of those spreadsheets where if you try to change anything, everything just falls apart.
I've attached a screenshot here: http://imageshack.us/photo/my-images/710/dolasci.jpg/

Honestly, I could just crunch all these numbers by hand, but it would take forever. Is there a way to speed things up using formulas? The biggest headache is those merged cells with descriptive text—I really need a way to make sure the formula ignores them entirely.

Thanks!

George Fox23 said:It's already an existing document, so tweaking it isn't really an option. Plus, the middle ground here isn't exactly great when you try to change things up.

Check out some examples on

- Sherlock Holmes plus the report

- working hours in Excel

So, here’s the situation: I’ve been working on a 14-page paper in Microsoft Word, and I’ve run into two specific issues.

First off, I jumped straight into Chapter I on the very first page, but I actually needed an introduction there.
Now I’m stuck wondering how to insert that intro so it sits on page one, while Chapter I starts properly on page two.

The second issue is that the spellcheck isn't catching my mistakes, which I know are there (for example, if I accidentally type Froum instead of Forum).
Is there some separate little program I should be using for this, or can I just fix the settings within Word itself? Otherwise, I'm going to have to go through everything manually.

😕

slyviper6 said:So, here's the deal: I was working on a paper in Microsoft Word (about 14 pages long) and I've hit two snags.

The first issue is that I jumped straight into Chapter I on the very first page, but I actually needed an introduction there.
Now I'm stuck—how do I squeeze that intro in so it sits on page one, leaving Chapter I for page two?

The second headache is that the spellcheck isn't catching my mistakes, which I know are probably there (like if I accidentally type Froum instead of Forum).
Is there some little utility for this, or can I just tweak the settings in Word itself? Or am I doomed to fix everything by hand?

😕

First off, which version of Word are you running?
If you're using the 2007 version, just put your cursor at the very beginning of your text, go to Insert -> Blank Page, and a fresh page should pop up right above your work... Alternatively, you could just stick the cursor at the start and start typing your intro; everything else should just shift down automatically.
If you have the 2007 edition, you likely don't have the American English dictionary installed, which is why Word isn't flagging anything! You basically have two paths: buy an official language pack upgrade from an authorized Microsoft Office site, or just head over to this website, paste your text in, and let it highlight your errors. Here’s the link: http://www.grammarly.com/. It'll flag all the typos with green boxes, and if you click them, you'll get a menu to pick the correction you want!

Dana Diaz8 said:First off, which version of Microsoft Word are you even running?
If you're stuck using the 2007 version, just put your cursor at the very start of your document, go to Insert, and select Blank Page. That should pop a new page right above your current text. Honestly, you could also just click at the beginning and start typing; everything will naturally push down the page automatically.
Since you're likely on the 2007 build, you probably don't have an American English dictionary installed, which is why Word isn't flagging any errors. You really have two choices here: either pay for a Microsoft Office upgrade to get the proper language pack from an authorized Microsoft site, or just head over to this website, paste your text in, and let it highlight your mistakes. Here is the link . Any misspelled words will be marked with a green square, and if you click them, you'll get a menu where you can pick the correct spelling.

Thanks, 👍

Hey,

Is there actually a way to crack a locked PowerPoint presentation? I’ve tried basically every sketchy tool on the internet (probably missed a few, but who cares), and all I get is some error saying the password is too long for the software to even handle 🙂 I managed to figure out the first three letters, but the whole thing is 10 characters long 😲

If cracking it is a dead end, does anyone know how to fix the font issue? I need to convert this presentation from Cyrillic to Latin script, but since it's locked, I can't copy any text or change anything within PowerPoint itself...

I'm not asking for much, am I?! 😍

If you’re trying to switch from Cyrillic to the Latin alphabet, just head over to Google Translate. Or better yet, try using a PDF to Word converter.http://www.pdftoword.com/.
Honestly, it should convert everything into a Word document without any drama, and once it's in Word, you can just copy whatever you need.

Hey there,

So, I've run into a bit of a headache with Excel. Ever since I had to wipe my computer and reinstall everything, the whole Cut-Pasta thing just isn't working for me.
I can still copy and paste, sure, but it's driving me nuts—it won't keep the formatting at all. It's just dumping raw text into the cells instead of keeping things looking the way they should.

Anyone happen to know a fix for this?

thanks 🙂

casualheron12 said:Hello.

I'm running into an issue with Excel. Ever since I had my computer reformatted, the Cut-Pasta function hasn't been working at all. Any ideas?
Can I use only copy-paste? Right now, the cells aren't retaining their original formatting—it's just dumping the raw text. Why does that happen?

Does anyone know how to fix this?

Thanks. 🙂

How do I run an Office repair?

Hey everyone, I've run into a bit of a situation. I could really use some help with a few Excel tasks—if there's an Excel wizard or anyone who's actually good with math formulas out there, please hit me up via PM or just reply here. I'm happy to pay you back with some Starbucks gift cards or whatever works. I have to turn this in by tomorrow morning, so I'm definitely feeling the crunch. Any help at all would be huge.

Here are the assignments:
1.http://www.2shared.com/file/2bp6r6dK/Book1.html

2.http://www.2shared.com/file/0qnz1PlD/Book2.html

And I've attached images of the problems in case you don't have Microsoft Office installed.

1.http://img205.imageshack.us/img205/534/slika1p.jpg

2.http://img818.imageshack.us/img818/5286/slika2x.jpg

(all clean)

John Cooper65 said:Hey everyone, looks like I’ve run into a bit of a snag too.

Look, the tasks you're struggling with are basically Excel 101—stuff middle schoolers pick up in their first computer lab session. Honestly? That makes you a beginner. If someone just hands you the answers, what's the point? You won't learn a thing, and you'll be completely lost when the actual complex stuff hits your desk later on. If you want to actually learn, check out this link: http://www.microsoft.com/en-us/office/excel2003/excel38.html It lists all the commands used in Excel 2003, which work perfectly fine in any other version of Excel, too. Now, the ball is in your court. Are you going to actually study this and figure it out, or would you rather just send a deposit to my bank account? If the cash clears, I can have those solutions in your inbox within five minutes. Your call.😂

I need help ASAP! I'm trying to number a term paper in Word, but I've set it up so the numbering starts at the Table of Contents instead of the title page. My professor wants the Table of Contents to count as the first page, but without an actual number showing up on that page—the "2" should only appear on the following page. How do I pull this off?