Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

Alright, if you're up for it, could you walk me through how I can set things up so that when I hover my mouse over an image or a block of text, those little pop-up balloon tips—you know, the ones with the descriptive text—actually show up?

My work computer has an original version of Office 2007 installed, but it’s set to Slovak.🤣 Naturally, I want to switch it over to English, but I can't get it to work.
I've already adjusted all the regional settings and everything else seems fine, but when I try to change Office, I keep getting this "limited support" error:


I'm logged in as Administrator and have full access to everything.

Would it help to buy the English Language pack (though I think it might already be installed, so that shouldn't be the issue), or should I just uninstall Office and try to install English trial versions? My only concern is whether the original serial number will still work if I go that route.🤷

I’m not entirely sure if there’s already a thread dedicated to this—or even where the best place would be to ask—🤷

I was wondering if there is a way to switch Microsoft Office 2007 from English over to American English🤷...

I’m pretty sure you can fix this by just doing a fresh installation of Microsoft Office in the language you actually want to use.
Basically, the entire suite needs to be set to that specific language right from the jump.
Installing a language pack is fine if you just need help with grammar checks or minor tweaks, but it won't actually swap out the main interface language of the software itself.

Hey,

So, quick question: how do I print a specific number of tiny labels on an A4 sheet? Not like a mass mailing or anything, we already have the sticker paper ready to go...

I'm talking about those little product labels, you know? Like the small ones you see on stuff at Target.

Thanks in advance!

Fiat Doblo? Please. If you’re looking for a reliable workhorse, just grab a Ford Transit Connect or a Chevy Express and call it a day. No need to overcomplicate things with weird imports. kaže:
The stickers would basically be the size of those tiny nutrition facts labels you see on food packaging.

Check out these tutorials.

- Labels in Microsoft Word 2003
- Labels in Microsoft Word 2007

Hey there,

The question is in the title. If there’s already a thread about this, my bad—I couldn't seem to find one... I'm trying to figure out how to set up Microsoft Office (specifically Word 2007) or maybe Google Sheets if Word won't cooperate, to scan through a full document and count exactly how many times a specific highlighted word appears. 🙂

Thanks...

Robin Jackson63 said:wondering how to set up Word (2007) or maybe Excel (if Word won't do it) to count how many times a specific highlighted word shows up in the whole text?

If you just need a quick count, Word won't explicitly show you the total frequency on the screen. Just hit the FIND button and search for the word. After you use the Highlight button, it’ll tell you exactly how many times that word pops up in the doc.

Kyle Johnson2 said:If you're just looking for a quick way to count how many times a specific word pops up in Word, the software doesn't exactly give you a running tally on its own. Instead, head over to the FIND button and use it to mark the word you're after. Once you hit the Highlight button, it'll show you exactly how many times that word appears throughout the document.

Once you've found it, just go to Reading Highlight and then select Highlight All

Thanks, Jane! 🙂

John, thanks for the stickers, I finally figured out how to do it myself!

I currently have Word set to English, but I really want to switch it over to American English... do I need to reinstall the entire Microsoft Office suite, or should I just be looking at my OS settings?

Honestly, you just need to go ahead and install the English Language pack for Office—it’s only about 200-something MB, so it shouldn't take long at all.

I’ve run into an issue, assuming there even is a solution. Lately, I’ve been downloading lyrics from various artists, and in this specific case, I'm using a chorus by Zečič:
If I have to be the first to say it,
I still love you, I'm still crazy for you.
I turned my back on happiness with him,
but I can't tell him goodbye.
I'm still crazy for you 2X

That "2X" notation implies the entire chorus should be repeated twice, yet some people interpret it as only repeating the final line.
The ideal way to format this would look like this:

If I have to be the first to say it,
I still love you, I'm still crazy for you.
I turned my back on happiness with him, } 2X
but I can't tell him goodbye.
I'm still crazy for you

Here is the problem. When I use a curly bracket and input a value like 100 (since that should roughly cover the whole chorus), the entire text just stretches out—it looks ridiculous and serves no purpose. Even if that actually worked, what happens with a four-line chorus? It means I'd have to manually move the curly bracket up and down, but how?
Is my only option to jump into PAINT, which just makes the job much harder?
Thanks.

Insert, Text box (just your standard text box in Microsoft Office 2007 or 2010)

So, you just draw it out, select it, right-click on the border, and set the Line color to: No color

Then you just type in whatever you want, make it any size you need, pop it wherever you feel like, and then just hit Ctrl+C and Ctrl+V as many times as you need to get the job done😁

Look, I’m having a hard time following you here. Can you just break this down? I’m trying, but it’s just not clicking.

Where exactly did you get stuck? 😁

Are you running Word 2003, 2007, or maybe 2010?

wearydriver50 said:Thanks, but I’m honestly lost. Can you break this down a bit more? I’m trying my best here, but it’s just not clicking.

If I’m following your train of thought correctly, what you’re actually looking for is a curly bracket that you can manually resize—something that can stretch to cover four lines of text. If that's the case, try this: open up your Word document, head over to the Insert tab, select Object, and then pick Microsoft Equation 3.0. A new toolbar should pop up, and at the exact spot where your cursor was sitting, an equation box will appear. On that new toolbar, find the curly bracket icon, click it once, and it’ll drop right into the equation area. Once you've done that, click somewhere outside that box. You’ll notice the area containing the bracket turns gray. Right-click on it, go to Format Object, hit Layout, choose Tight, and click OK. You should see little circles appearing around the bracket now; you can grab those handles and pull them wherever you want to stretch it out as much as you need. (I'm using Word 2003, by the way.)

Hi there,
I've been working on a production status report
In column "A", the inspectors log the inspection date; in "B", they note the specific shift; and in column "C", they list the quantity of non-conforming products. I am struggling to create a formula that sums up the total number of defective units for a specific date during the first shift. It is possible for the same date to appear multiple times because several different inspectors might perform checks, each logging their own entries separately.
Thanks in advance!

Sorry I couldn't get back to you sooner. Everything is sorted out now, thanks.

ironpuma62 said:Hi there
I’m working on a production control report
In column "A," inspectors log the inspection date. Column "B" is the shift worked. Column "C" lists the quantity of defective products. I can't seem to get a Formula to work that sums up how many non-conforming items were recorded on a specific date during First Shift. The problem is, the same date shows up multiple times because different inspectors are logging their own entries independently
Thanks in advance

Give this a shot: Put your dates in column A (say, from A4 to A30) and put the number of defective units in B4 through B30 specifically for First Shift. Set up a separate little table off to the side—put the months in H4 through H15, then in the column next to it (I), specifically from I4 to I15, you'll write the formulas that will give you the total defect count for each month.
-for Jan, type in I4: =SUMIF(A4:A30;" -for Feb, type in I5: =SUMIF(A4:A30;" -for March, in I6, type: =SUMIF(A4:A30;" -for April, in I7, type: =SUMIF(A4:A30;" .................................................. ...............................................,
-for Dec in I15, type: =SUMIF(A4:A30;" The dates in column A don't even need to be in order; the formula will find them regardless. I'm sure some geniuses around here might have found an even simpler way to do it, though.
Just replicate this process for all three shifts🙏you'd just be adding two extra columns to each respective table.