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

Here’s how I set up my tracker: Column A is for the DATE, B is CURRENCY, C is the TRANSACTION, D is the PURPOSE, E is DEBIT, F is CREDIT, and G is the BALANCE. You just pop your starting balance into the second row (2), then drag this formula down to calculate your running total =SUM(G2;-E3;F3) whenever you plug in numbers in columns E or F. Feel free to tweak it to fit your own style!

Jack Hayes said:Set up your columns like this: (A) DATE, (B) CURRENCY, (C) TRANSACTION, (D) PURPOSE, (E) DEBIT, (F) CREDIT, and (G) BALANCE. In the second row (2), you'll just type in your starting balance, and then from there, I guess you can just drag the formula down to calculate the running balance =SUM(G2;-E3;F3) based on whatever amounts you plug into columns E and/or F. You might want to tweak it to fit what you need, though.

I'm reading this, but I honestly don't get any of it...

Maybe you could just build it for me and upload the file?

I wouldn't really want to bother you since I don't really understand how this works... 😕

Gary Hernandez92 said:I’m sitting here reading through this, and honestly? I haven't a clue what's going on. It’s all just complete gibberish to me.

So, look, you just need to type your starting value right into cell G2. Then, take that formula Jack Hayes gave you and drop it into G3. Once that's set, just grab the corner and drag that formula down the column as far as you need to go. It’s pretty straightforward, really.
Look, we’re currently inputting all the raw data into cells E3, E4, and so on, then moving over to F3 and F4. Once that's done, column G will automatically calculate the final balance for you. Honestly, you can't just sit there waiting for everything to happen by magic; you actually have to put in some manual work yourselves...

cosmicdrifter39 said:... all I get is a bunch of ########## instead. Any idea how to fix the calculation? ...

I thought it was just because the result wouldn't fit in the cell, but here is what Google says
Code:

There really isn't any other way. I suppose I'll just have to follow a tutorial...

Thanks

Gary Hernandez92 said:Can someone who isn't too lazy please whip up a simple Excel sheet for me? It doesn't look like much work—just four columns—but I'm a total dummy when it comes to Excel formulas.

It’s not about being "lazy." Helping out is fine, but usually, the person asking actually puts in some effort first.

The thing is, you haven't tried at all. Even if you really are a "dummy," you could've at least set up the basic table and plugged in some sample data so whoever helps you isn't wasting their own time doing your grunt work. Besides, tutorials for making a spreadsheet are all over the internet.

- Here’s a basic template since you asked.

I’ve run into a bit of a headache with a formula—hoping some kind soul out there can help me out...

So, here's the deal: I have cells set up using Time format. Column A is the start time, Column B is the end time, and Column C calculates the total hours worked.

Now, I need a formula in a new column to calculate overtime pay based on specific rules:

***** If total work is 0-8 hours, it's $0.00. If it's 9-14 hours, it's $6.00. And if they hit 15+ hours, it's $12.00 *****

Here's a quick screenshot for anyone who needs to see what I'm actually struggling with. 🙂

Larry Fox5 said:Here's a quick screenshot for anyone still scratching their heads about this.

You can't actually work on a "screenshot," man. If you're gonna go through the trouble, just upload the file for download.
When you're dealing with adding up or subtracting work hours like you are here, just use an IF function paired with VLOOKUP.
For your specific setup, toss this formula into cell D2 (just make sure "value" is set up as a named range)
Code:

Then just set up a named range for your criteria—check that "little picture" if you need a visual.

I am reaching out because I could really use some assistance!
Is there a way in Excel to insert an image so that it is embedded directly onto the worksheet at a specific, predefined size? To be more precise: I would love for the image to automatically scale and snap to fit the range from B3 to K23 whenever I insert it. Ideally, I would want this behavior to apply consistently across all subsequent sheets as well.

Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

neonbadger53 said:I am in desperate need of some assistance here! Please, if anyone has a moment, I could really use your help.
So, I’ve been staring at my screen for far too long today, nursing this lukewarm coffee, wondering why things that should be simple always end up being such a massive headache. It’s like trying to fix a leaky faucet only to realize the entire plumbing system is shot. Anyway, back to the task at hand. I have someone asking about Excel—and yes, I am talking about Microsoft Office here, let's be clear—who wants to know how to drop an image into a sheet and have it behave itself. They aren't just looking to slap a picture on there; they want it locked down. Specifically, they want the image to automatically snap to a set size, spanning from cell B3 all the way to K23, and they want this to happen consistently across every single subsequent sheet in the workbook. It’s a specific request. A bit of a granular one. Most people just drag and drop and call it a day, but this user wants precision. They want that image to occupy that exact footprint, B3 through K23, every single time. Now, if you're looking for a "one-click" button that says "Make this image fit exactly these coordinates on every sheet," I hate to break it to you, but it doesn't exist in the standard interface. You can't just click a button and have Excel magically understand your spatial requirements across a whole workbook without a little extra work. If you want to do this properly, you're likely looking at a VBA macro. You’d need to write a script that defines the range, grabs the image, and forces its dimensions to match those specific cells. Without a bit of code, you're basically stuck manually resizing every single image on every single sheet, which—let's be honest—is a soul-crushing waste of time. I once spent three hours trying to format a spreadsheet for a client in Chicago, only to realize I'd missed one tiny formatting rule, and I nearly threw my laptop out the window. Don't be that person. Use a macro. It's cleaner.

Thanks! Seriously, thanks a million!

Maybe you could try messing around with the headers... you know, like if you just go in through the header settings... turn it on there... I mean, look, we really need to talk about the central section. It’s one of those things people just gloss over because they think they know what they’re doing, but trust me, if you don't get that middle part right, the whole structure falls apart. I was looking at this project last week—nothing major, just some data organization stuff—and I realized how much time is wasted because someone neglected the core segment. It's like trying to build a house on sand. You can have the best windows in the world, but if that central foundation isn't solid? Forget it. You're just wasting your breath and your budget. We need to be more deliberate here. Just focus on the center. Everything else is secondary. So, you're trying to get that image in there, right? First, you just go ahead and insert the picture you actually want. Then, once it's sitting on the page, you head down to the bottom right corner... Sheet1Well, here we go again. Honestly, I don't even know where to start with this one. It’s just... it's constant. Every time I think we've hit rock bottom with these discussions, someone pulls a stunt like this. It's exhausting, really. I was sitting there earlier, just trying to get some work done—trying to make sense of some messy data in Excel, mind you—and I just had to stop and take a breath because the sheer absurdity of it all finally caught up to me. It's like we're circling the drain. Anyway, let's just get into it. Select All SheetsLook, I’ve been staring at this for a while now, and honestly, it’s just how it works. Every single time you move to a new page, that exact same image—same dimensions, same damn thing—is going to be sitting there right in front of you. It's just what happens. I don't even know where to begin with this. Just... enough. Honestly, just enough. I find myself sitting here, staring at the screen, wondering how we even got to this point where things are so incredibly simplified or stripped down that there's nothing left to say. It’s like looking at a blank page after a long day of dealing with bureaucracy in DC—just a void. Sometimes you just need to stop. Stop the noise, stop the constant influx of nonsense, and just sit in the silence for a second. It's exhausting, really. The sheer exhaustion of trying to make sense of it all. Anyway, I'm rambling. My apologies. Just one of those moments. Just hit Print preview to see exactly what’s going to come out of the printer. It's the only way to be sure before you waste a whole stack of paper.

neonbadger53 said:I want any image I insert to automatically snap into the B3 to K23 range!

Look, you can totally use a VBA macro to dump images into a specific range, but there's a catch: your cell widths and heights have to be uniform for it to look right. I put together an example for you here:

- How to insert images into multiple Sheets using VBA

So, I’ve run into a bit of a situation in Excel. Every time I type in a number, it formats it as 10,000.00 instead of the 10.000,00 style I'm used to seeing. 🙂
Is there a way to just swap the positions of the decimal point and the comma?

Just head over to your Regional Settings and you can get that format dialed in right there.

Walter Jackson48 said:Just head into your Windows Regional settings and adjust the format there.

Could you maybe be a little more specific about that?

Go to Control Panel -> Region and Language -> Formats—that’s where you’ll find the number formats. Just dive in there and swap out the decimal symbol and the digit grouping settings.

How do I fix this?
Every time I type "I am writing a letter" in Word and hit enter, the software decides to be a genius and changes it to "I am writing a description" or something else entirely. It’s basically rewriting my sentences on the fly. I already tried messing around with the language settings to get it to stop, but no luck so far.
I'm using Office 2010.
Thanks for the help!

analogeagle72 said:How can I fix this?
In Word, I type "Writing a letter," hit enter, and suddenly it changes to "Writing a description" or something similar—basically, my sentences keep changing on me. I tried adjusting the language settings, but no luck...
I'm using Office 2010.
Thanks for any help

Just disable AutoCorrect under Proofing—specifically, uncheck the "replace text as you type" option.

hiddenotter98 said:Just go into your proofing settings and kill the autocorrect—basically, uncheck that "replace text as you type" option.

My Office is set to American English, so I can't find the specific menus you guys are talking about.
Thanks for the help, everyone!

analogeagle72 said:My Office is set to American English, so I can't find half the stuff you guys are talking about.
Thanks in advance for the help!

Actually, turns out my English is good enough to figure it out on my own anyway. Problem solved. Thanks again for the assist!

analogeagle72 said:My Office is set to American English, so I can't find what you guys are describing
Thanks in advance for the help

I struggle with the American version too...😬

But I did find this http://office.microsoft.com/en-us/su...277.aspx?CTT=1

So:
Click the File tab.
Click Options.
Click Language.
Then Proofing and Self-correction.
Click AutoCorrect Options.
On the Self-correction tab, check if the box is checked for Replace text as you type.

Well, you actually need to uncheck that last box...