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

I’m trying to lock certain cells in Excel while keeping others wide open for data entry. For instance, I need the name and surname fields to be completely locked,
but the cell right next to them needs to stay unlocked so someone can actually type in it. I tried messing around with the "Format Cells" option to lock the cells and then protecting the workbook,
but frankly, I haven't quite grasped the logic behind it. It keeps locking things that should stay free and leaving things open that ought to be restricted—it's maddening. Is there a more intuitive way to handle this?

There is a trick where you can set it up so that when you use the arrow keys to navigate the sheet, you only jump between the specific cells that are actually open for input.

Bradley Murphy56 said:I need to lock some cells in Excel, but leave others open for data entry. For instance, the name and surname fields should be locked,
but the cell right next to them needs to stay unlocked so I can type stuff in.

No need to lock the whole Workbook if you just want to lock specific cells on a Sheet. Check out these tutorials, follow the steps, and hit me up if you get stuck.

Well, things have slowed down. That should be about it for now. Talk soon.

Brenda Barnes said:I find myself in the following situation...
Sheet1 consists of two columns: client name and zip code...
Sheet2... It contains a list of all the post offices across America—just two columns: zip code and city name...
I'm looking to add a column for location names into Sheet1—pulling that data directly from Sheet2... I'm certain there's an Excel way to automate this, I just haven't managed to track down the specific method yet...
The sheet contains roughly 4,000 clients—this would save me quite a bit of time...

Does anyone know how to handle this...?

If that zip code database was pulled directly from HP's site, there might be an issue with trailing spaces at the end of the city names—which would break a VLOOKUP if you're searching by location... especially since multiple towns can share the same zip code.
This needs to be cleaned up first...
=TRIM(SUBSTITUTE(A1, CHAR(160), CHAR(32))) — essentially cleaning up those stubborn non-breaking spaces... keeps things tidy.

Betty Hayes10 said:It spits out a full number followed by the letter M:
$4,500,000.00 M

Look, if you’re building that chart based on cell B1 (which was my first post on this whole thread), then the top of the bar should be showing $45.60 M, which means in your specific case, it ought to read $45.00 M.
The only real issue here is that we aren't getting enough info from you. We're basically flying blind, guessing what you actually need, and then throwing solutions at the wall to see what sticks.

Betty Hayes10 said:It's spitting out a number followed by an 'M':
$4,500,000.00 M

Check this image. Help you out?

Excel experts, I need some guidance and best practices here.

What’s the most efficient way to wrap my head around macro logic and actually write VBA (Visual Basic for Applications)?

Here’s the situation: I’m dealing with duplicate headers exported from our data system. They aren't consistent—one day they land on row 41, the next on row 43, and it's always shifting. I need a way to programmatically identify these redundant headers regardless of where they pop up and wipe them out.

I’m stuck manually cleaning these duplicates every single morning. I want to automate this to save time and stop wasting effort.🙂.
Thanks in advance for any help or insight you can offer.
Best,

Hey everyone!
I'm coming in here like a total amateur to ask if there's any way to download Microsoft Excel 2010 for FREE from somewhere online. I checked their site and saw they offer a free trial for the full Microsoft Office suite, but they demand a credit card number upfront. Honestly, that’s just a huge pain in my neck because I don't even use my cards for online shopping.
So, what's the move here? How do I actually get my hands on Excel 2010 without all that hassle?

Ashley Kern17 said:What's the easiest way to wrap my head around macro language and actually build stuff, basically VBA (Visual Basic for Applications

Look, I'm no "expert," but if you want my two cents: the best way to get VBA is just to dive in and learn by doing. Hands-on practice
is everything.

Kyle Johnson2 said:Look, I’m no "expert," but if you want my advice, the best way to actually grasp VBA is through hands-on practice and just getting your hands dirty with the code
.

wow, this site is great. I was just about to start teaching myself Excel using this instead of some dusty old textbook—it’s definitely more concise and easier to follow... but does anyone know how the hell I can get my hands on Excel 2010? 🙂
I’ve only got the 2003 version on my computer, which is what this page seems to be built for, but I really need to master Excel 2010.

Look, you can't just download something for free if it isn't actually free—it’s not rocket science. And please, let's not go looking for pirated cracks or sketchy workarounds on this forum.

If you want a legitimate way to test it out, you can grab the trial version right here: http://technet.microsoft.com/en-in/e.../ee390818.aspx

Ashley Kern17 said:What’s the easiest way to actually wrap my head around the language used in macros—basically, how to write VBA (Visual Basic for Applications)?

Look, if you don't have any background in programming—and I mean zero—and you aren't dealing with a task that can be solved by simply recording a Macro command (which, based on what you've described, clearly isn't working for you), then honestly? It might be more practical to just find someone who can build it for you for a little bit of cash.

Benjamin King2 said:Look, you can't just grab it for free if it isn't free. And don't come looking for pirated versions on this forum.

If you want the trial version, you can get it right here: http://technet.microsoft.com/en-in/e.../ee390818.aspx

Thanks so much!!!! 🙂

Everything's sorted now. Link.
I had to get my cell formatting dialed in before I actually typed the number in, not the other way around. Does that make sense?

Thanks, everyone! 👍

Walter Jackson48 said:If you're building that chart based on cell B1 (which was my first post in this thread), then it should be showing $45.60 M above the "beam" of the chart, whereas in your case, it's displaying $45.00 M.
The only real issue here is that if we aren't given enough details, we're just left guessing what you're trying to achieve before we can even offer a solution.

Kyle Johnson2 said:Will this image help you out?

Alright, so I’m running into this headache in Excel with some work hours. I've got one cell sitting at 184:00:00 and another at 181:15:00, and when I try to subtract them—you know, doing 181:15:00 minus 184:00:00—the cell just spits out those annoying ########## instead of showing me a negative time value. It's driving me nuts. How do I actually get this calculation to work? I see a bunch of people here who look like they basically helped build Excel from the ground up, so I’m banking on you guys having a fix for my little struggle here.

cosmicdrifter39 said:it won't let me display negative time values in my cells

I mean, what does "negative time" even actually signify—setting aside how Excel behaves? In what realistic scenario would you ever need to account for "minus two hours" in a calculation?

You could just use =ABS(A1-A2) to get the raw difference, and then handle whatever sign logic you need using an IF statement.

Nicholas King said:What does "negative time" even mean, anyway? Setting aside all that Excel nonsense for a second—where in the real world would you actually use "minus two hours"? Like, what does that even look like in real life?

Look, you can just toss in =ABS(A1-A2) to grab the difference, then deal with whether it’s positive or negative using an IF statement later. Simple enough.

So, here's the deal. I've got 184 hours set as my standard full-time workload for January. If someone clocks in at 181 hours, they’re technically 4 hours short. I was thinking—is there a way to make Excel actually show that deficit as -4:00 in a cell? I need to be able to run more math on those negative numbers without everything breaking.

cosmicdrifter39 said:So, if I consider 184 hours to be my total working hours for January, anyone who worked 181 hours would technically be down by 4 hours—and I was wondering if there is any way to display those 4 hours in a cell as -4:00 so that I can actually use that value for further calculations.

Well, you have a few different ways to approach this:

- You could calculate the absolute value instead, then just handle the negative result using an IF statement;

- Or, you could simply format the cell containing the negative hours as a standard number rather than a time format—this won't change the actual underlying value, it just means instead of seeing -4:00:00, you'll see something like -0.1666667.

- Alternatively, you could switch over to the "1904 Date System."

Betty Hayes10 said:Everything is sorted out now.

Thanks, everyone!

A little bit from everyone, but you really went above and beyond—there's the fix.

Hello,

I was wondering if someone might be willing to put together a simple Excel spreadsheet for me. I'm looking for a few basic columns: one for the date, one for the event name, one for income, and one for expenses, with everything totaling up at the end. Just enough rows to cover a 31-day month, I suppose.

It seems like such a small task, just those four columns, but I guess I'm a bit out of my depth when it comes to Excel formulas...🙂

Thanks in advance.