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

Look, there’s actually an easier way to handle this if you just take a second to breathe:
First, go into your Excel Options and set your separators exactly how you want them. Once that's sorted, when you have your spreadsheet open, look up in the toolbar—you'll see that little icon for Comma style. Just click into whatever cell you're working on, hit that button, and boom, the cell is formatted. You type your number in, and it'll snap right into the format you picked. And hey, if you want to be efficient, just hold down the Ctrl key to grab a few different cells at once and apply it all in one go.
Actually, if you really want to save time—and I know I hate wasting clicks—just hit Ctrl+A to select every single number on the entire sheet, click that Comma style icon, and the whole thing updates instantly. Easy as that.

Hey everyone.

I’ve been stuck on this one problem for days now. I need to build a macro for a protected Excel sheet—something that runs a spell check and actually highlights the cells where the errors are. For some reason, Excel isn't doing it automatically (it doesn't guide me through the text or cells like Word does), so I have zero clue where the misspelled words even are.
I've scoured every forum out there and Googled everything, but I figured my people over at Reddit might actually have the answer. 🙂

If anyone feels like helping out...
This is the code I'm running. It works fine for the actual spell check, but it won't highlight the specific cells containing the mistakes:

Sub Spell_Check()
ActiveSheet.Unprotect password : = "password"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect password : = "password", DrawingObjects:=True, _
Contents:=True, Scenarios : = True end Sub

End Sub

Thanks guys.

Later.

Alright, here’s the deal—I’m working on a document that mixes portrait and landscape orientations. When I apply page numbering, the landscape pages end up with the numbers sitting at the very bottom. Since this is being bound for a physical file, I need those landscape page numbers positioned on the right side—specifically for the landscape pages only—so they’re actually visible when someone flips through the printed work.

Detailed breakdown here:

electricmarlin18 said:I want them numbered on the right side (only for landscape pages) since this is for a formal record that'll be bound—page numbers need to be visible when flipping through the doc.

Just go to Insert page number within the margins.

Sandra Wells12 said:Sub Spell_Check()
ActiveSheet.Unprotect Password:="password"
Cells.CheckSpelling SpellLang:=1033
call ProceduraZaOznacavanje
ActiveSheet.Protect Password:="password", DrawingObjects:=True, _
Contents:=True, Scenarios:=True

End Sub

Looks like someone else is dealing with the exact same thing. You're gonna need to add a procedure to highlight those cells or text.

Kyle Johnson2 said:From what I can tell, someone else has an issue just like yours. You probably need to add a procedure to highlight the cells or the text itself.

Thanks, Kyle Johnson2

The thing is, I know what I need to search for and identify, but I have no clue how to actually write the code.😕
Can anyone help me out? 🤷

Sandra Wells12 said:The issue is I can find and recognize code, but I can't actually write it. Can anyone help me out?

Honestly, I'm not much of a coder myself either. 🙂

Give this a shot and let me know if it fails—we'll try something else.
It's a simpler way using one single VBA script. Just make sure you update the "Sheet1" name.
Copy this VBA into the Sheet module
Code:

Kyle Johnson2 said:Look, I'm no coder myself, so 🙂

Give this a shot and let me know if it fails. Maybe we can try something else.
It's just a simpler way using one VBA macro. Just make sure you change the name for Sheet1
Copy this VBA into the Sheet module
Code:

Sub colorCigarette()
ActiveSheet.Unprotect password : = "password"
dim C as range for Each C in Worksheets("Sheet1").UsedRange 'The Sheet where we check for errors
if not Application.CheckSpelling Word:=C.Text Then _
C.Interior.Color = vbYellow
Next C Cells
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect password : = "password", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Thanks for trying, but it's not working...
Basically, Excel changes the background color on the protected cell where it finds an error—it's doing it in the header, but I need it to check the whole sheet, specifically the part where users enter data. The protected part is just the header, formulas, etc.—stuff that shouldn't be touched.
Also, I don't want it changing the cell background color. I just want it to mark the cell (unless it can highlight the word itself like in Word)
And stop jumping me through every single cell where it finds an error...

Seems so simple... but...🙂🙂 🙂🙂

Sandra Wells12 said:Thanks for trying, but it's just not doing it... I need it to scan the whole damn sheet for errors, especially where people are typing stuff in... plus, it doesn't actually take me to the cells where the mistakes are...

Give this a shot

Code:

Good afternoon,

I'm trying to put together a specific chart in Excel—it's proving to be a bit more stubborn than I anticipated—so if anyone could lend a hand, I've attached an image showing exactly what I'm aiming for.

http://s9.postimg.org/5r73hn0lr/Grafikon.jpg

Everything you need should be right here. It's a pretty straightforward task... let me know if you get stuck on anything.

Kyle Johnson2 said:Give this a shot.

Code:

With Worksheets("Sheet1")
.Activate
.Range("B3:D5").CurrentRegion.Select 'change the range if you want
End With
Application.CommandBars.FindControl(ID:=2).Execute

That's it. That's exactly it.
It’s working like a charm!!! 🙂
Thanks a lot, Kyle Johnson2. I owe you a beer. 🙂🙂🙂
Thanks!!

Matthew Garcia4 said:help me out with an Excel chart if anyone can

here go ahead and mess around with this 🙂

To whom it may concern,

How exactly does one go about drafting a function to resolve this particular dilemma?

If one were to observe that the value within cell E20 falls anywhere between the years 2008 and 2013, and simultaneously finds that E21 resides within the range of 1401 to 2000, then it follows—quite logically, I should think—that E24 = H7.
Thank you.

Quick question...

Can Word 2010 open files from Word 2002? And vice versa... I know you have to save them differently, but I'm asking anyway.

Angela Ramirez4 said:Hey there,

I'm trying to figure out how to write a function for this specific issue...

"if E20 is between 2008 and 2013, and if E21 is between 1401 and 2000, then set E24 = H7"
Thanks.

So, if we plug this formula right into cell E24:

=IF(AND(E20>=2008,E20=1401,E21
Is that actually what you're looking for?

Bryan Chase9 said:Can Word Office 2010 open files from Word 2002? And vice versa... I know you have to save them differently, but just asking.

Why wouldn't it work? As long as your Word isn't broken, it should be able to load old docs or save them down for older versions. Check the second screenshot in the tutorial. You just gotta pick the 'Word 97 - 2003 Document' option

Talking about the laptop...

Does every version of Microsoft Office Word have that option for Word 97 - 2003 Documents?
Because I can't get it to work on this old Toshiba laptop of mine.

It all boils down to the file extension—doc is just the old-school format for Word 2003 and anything older, whereas docx is what you'll see in the 2007 versions and up. If you're stuck using an older version of Office, you’ll need to grab a compatibility pack if you actually want to open those newer docx files. And honestly? Your laptop has absolutely nothing to do with it.

Hey everyone,
Can someone please help me out? I’ve been struggling with this for a few days now and it's driving me crazy. :// So, basically, while I was trying to set up page numbering for my thesis, I went a little overboard with the page breaks. Now I've ended up with nine different sections, and I can't figure out how to delete them—it's like they're stuck. Also, I need every page with a main heading to have no page number at all, so if anyone could explain how to fix that without me losing my mind for another week, 🙂 I'm using Word 2010