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

Spell check
Translate the text into American English and run a spell check on it.

Michael Kelly11 said:Got some text in Word but all my accented characters are missing. Any tricks to get the program to auto-fix them?

Building on what everyone else said, just lean on the built-in tools in Word

- Find/Replace
- VBA Macro Find/Replace
- Find/Replace using special characters (you can do a lot here, like targeting specific word fragments and stuff)

Say I have a dataset with columns for company name, product, stock levels, product class, and order count.

Does anyone know how to build a report where, upon opening, I can select a company from a dropdown menu, then pick a specific product to pull its stock, class, and order data?

Hey everyone!
I could really use some help with Excel. I’ve written this VBA code to sum up cells based on their color—which is super handy—and since I need to use it across all my different workbooks, I tried saving it into my Personal folder. But here's the kicker: it just isn't working. When I hit Alt+F8 to run a Macro, the code doesn't even show up in the list. It’s driving me a little crazy because when I paste the code directly into a specific file, it works perfectly fine.
I'm honestly stumped... am I doing something wrong here? Is there some kind of restriction where certain types of code just won't run if they're tucked away in the Personal folder?
Thanks so much for any help you can give! 🙂

Does anyone know how the heck I can make this line vertical in Word???

I need help here!

Laura Thomas28 said:help

The whole thing was built inside a spreadsheet. Basically, that entire column you're looking at is just your line.

Laura Thomas28 said:How on earth do I make this vertical line in Word???

Look, I might have a solution for you if you're struggling: Go to Format, hit Columns, and set your page layout to two columns—you know, like a standard newspaper setup. Once you've got that, just grab the Drawing tool, pick the Line option, and simply draw a vertical line right down the middle of the sheet. It’s not rocket science, really.

Hey there,

Does anyone know how to clear out duplicates within a multi-selection in Excel? For example:

5 5
5 6
6 = 8
8
5

8 8
6 6
5 = 5
8
6

I've got this massive table with about 10,000 rows broken down into roughly 2,000 different groups—so hitting "remove duplicates" manually for every single group is becoming a bit of a headache.

I'm currently grinding through a book using MSW 2010—everything's fine in the main body, except for one massive headache I can't seem to shake. When I pull up the navigation pane, the chapter tree works just fine—I can jump back and forth without a hitch. But the numbering? It's a complete disaster. Some parts look okay, but then it just falls apart. Here’s what I’m seeing:
...
2.
2.1
3
3.1
3.2
3.3
0.2
1.1
e)
1.2
...
Everything is perfectly normal right up until chapter 3.3. Then—boom—chaos.
Quick question:
How do I actually get Word to auto-renumber all my chapters and subchapters properly so they actually follow the hierarchy?
Thanks in advance.

Christian Adams79 said:Hey,

Anyone know how to strip out duplicates in Excel when you've got multiple selections going? Like this:

..............
I'm staring at a table with 10,000 rows split into about 2,000 different groups. Man, clicking "remove duplicates" for every single group is killing me.

check this tutorial

- Duplicates in Excel

vividlynx7 said:how do I get Word to auto-renumber all my chapters and sub-chapters so the whole tree structure stays intact?

check out this tutorial, might help you out

- Word 2003 content
- Word 2007 content

Hi everyone, I have a bit of an Excel puzzle on my hands, so I’m hoping someone here might be able to point me in the right direction... Let's say for example I have a list of numbers from 1 to 10 sitting in column E, and then I have another set of numbers from 1 to 10 over in column H.

What would be the best way to count how many times a specific value—let's say the number 3—appears in column H, but only if the corresponding cell in the same row in column E contains the number 1?

I ended up finding it by using a COUNTIFS formula...

One way you could tackle this is by adding a helper column—let's say Column I. In cell I1, you’d plug in this formula:
=IF(AND(E1:E10=1;H1:H10=3);1;""), then just drag that formula down to I10. After that, pop this into I11: =COUNTIF(I1:I10;"1"). There are probably much more elegant ways to handle this, honestly.

(Sorry, I'm a bit late to the party here. I didn't catch your solution earlier.)

Brenda Ortiz51 said:Hey everyone!
I could really use some help with Excel. I wrote this VBA code to sum up colored cells—super handy, right?—and since I want to use it across all my workbooks, I tried saving it in my Personal folder. But here's the kicker: it just won't show up. When I hit Alt+F8 to run a Macro, it’s nowhere to be found. The weird part? A test code works perfectly fine, but this specific one doesn't. It only runs if I keep it inside the individual file itself.
I'm honestly stumped... am I doing something wrong, or are there certain types of code that just don't play nice when they're tucked away in the Personal folder?
Thanks so much for any help 🙂

Is it just me, or did I phrase this poorly? Does anyone know what might be going on? 😢

Give this a shot: Open up your spreadsheet, head over to Tools, then Macro, then Security, set it to Low, and hit OK. Go ahead and Close the file by selecting Yes. Now, try opening it back up again. It’s possible the security settings are cranked up too high, which would explain why the macro isn't cooperating.

Brenda Ortiz51 said:Does nobody know, or did I just mess up the question? 😢

check out this tutorial, might help you out

- How to sum data based on cell color

Walter Jackson48 said:Give this a shot—open up your sheet, head over to Tools, then Macro, then Security, and set it to Low, then hit OK. Go ahead and Close the file by clicking Yes. Now, try opening it back up again. It’s possible the security level is just set too high, which would explain why the Macro won't run. Ever had that happen? It’s always something, isn't it?

Kyle Johnson2 said:Take a look at that tutorial—maybe it’ll actually help you get this sorted out?

- So, I was staring at my screen for way too long this morning—probably should have grabbed another coffee first—and I hit one of those classic Excel hurdles that just makes you want to throw the whole laptop out the window. Have you ever been there? You’ve got this massive spreadsheet, and for some reason, everything is color-coded. It looks great, sure, but now you need to actually *do* something with it. Specifically, you need to sum up all the values in cells that are a certain color. It sounds like such a simple request, right? Just "add up the blue ones" or "total the red ones." But if you go looking through the standard menus, it's like they forgot this was even a possibility. There isn't just some magical button labeled "Sum by Color" sitting there waiting for you. I started digging into it, thinking maybe there was a quick shortcut I missed, but it turns out it’s a bit more involved than just clicking a button. You can try using the Filter tool—you know, where you filter by color and then use the SUBTOTAL function—but honestly, that feels like a bit of a workaround, doesn't it? It works, but it's not exactly elegant. Then there's the "pro" route: VBA. Now, don't let that word scare you off—I know, I know, macros can feel intimidating—but writing a little custom script is actually a pretty solid way to handle this if you do it often. You basically create a tiny little function that tells Excel, "Hey, look at the background color of this cell and add it up if it matches." It’s a bit of a rabbit hole once you start tinkering with it, though... I ended up spending twenty minutes just adjusting the font size of my code. Classic me. Has anyone else run into this? Or am I just overthinking a problem that could be solved by just... I don't know, coloring the cells based on their actual values instead? Is it better to change how the data is organized from the start, or is it worth the effort to build a custom tool to fit the mess we already have? I'd love to hear how you guys tackle this when the spreadsheet starts looking more like a rainbow than a data set.

Thanks, but honestly—it’s no use. None of that really helps me out at all.

So, I went through this tutorial and pulled out the code—specifically that fourth example—and it works just fine in one specific file. But, the tutorial says if you want to use this code across all your Excel files, you should save it in your Personal folder, right? So, that’s exactly what I did. The problem is... it just won't work from there. I tried running a test Macro directly from my Personal folder, and that works perfectly fine—no issues at all—but as soon as I try to run this specific one for the color function, nothing happens. It's like it's hitting a wall. Does the code itself have some kind of built-in limitation that prevents it from running when it's sitting in the Personal folder? Is there something I'm missing here?

Maybe you could try getting that Macro to stick by using the Save as function. You know, go down to the "Save as Type" option and just use the little arrow to pick the right format from the dropdown menu. It’s a bit of a hassle, I know, but sometimes that's the only way to make sure the software actually remembers what you did instead of just tossing it out the window. So, I was staring at my screen again today—just me, a lukewarm cup of coffee, and the endless grid of Excel—when I started thinking about those old-school MS Excel Add-In (*.xla) files. You know the ones. They’re like those vintage muscle cars sitting in a garage; they might look a bit dated to the uninitiated, but if you know how to tune them, they still pack a punch. I remember back when I first started out in Chicago, trying to make sense of massive data sets for a firm downtown, I used to rely heavily on these specific add-ins to automate the grunt work. It’s funny how things change. Nowadays, everyone is obsessed with the newest cloud-based shiny objects, but there’s something to be said for a solid, reliable Macro that just *works* without needing a constant internet connection to validate its existence. Anyway, I digress. If you're looking into working with an Excel Add-In, just make sure you've got your Security settings dialed in correctly. You don't want some rogue script running wild on your machine because you were too lazy to check the permissions. It’s like leaving your front door unlocked in the middle of the city—not exactly a brilliant move, is it? Just a thought while I try to get this spreadsheet to behave itself. It's being particularly stubborn today. Honestly, sometimes I think the software is doing it just to spite me.Look, you just need to go into Tools, then hit Add-Ins, and simply check the box next to whatever name you gave it. That’s it. It’s worth a shot, really. I mean, sometimes these things just work if you follow the steps, even if the interface feels like it was designed by someone who hates us. Just give it a try.

Hello there,

I am quite new to this community and I am not entirely certain if this topic has been covered before, but I am currently struggling with page numbering in Word 2007. Specifically, I need my numbering to begin on the fifth page so that it displays as "1." I managed to find a tutorial online to guide me through the process, yet I have run into a bit of a snag. While the fifth page does correctly show up as the first, the sixth page also insists on being the first, and then the numbering doesn't actually progress to "2" until the seventh page. If anyone could kindly provide a step-by-step solution, I would be incredibly grateful, as I am admittedly a bit of a novice when it comes to these technical matters.🙂

Thank you all so much in advance!