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

Dana Diaz8 said:It sounds to me like you're running some pirated version of Office, likely some buggy crack you pulled off a shady site... ☕

P.S. I know we aren't technically supposed to bring this up on this thread, but I figured I'd say it anyway just so people can stop wasting their lives spinning their wheels over it.

Quite the opposite.
I would never personally shell out the cash for that junk, but my previous employer provided it as part of my workstation setup.
Besides, looking at the forums, most people complaining about this exact same issue seem to be using legitimate versions.

Need some help here.
So, I've got these two separate charts—they gotta stay on their own individual slides—but I really want a way to compare them in one go. It would be way easier to actually see the gap between them if they were combined, but honestly... I have zero clue how to pull that off.🤷

Hi there. I’m looking to build a more advanced algorithm in Excel—though it doesn't strictly have to be Excel, since I already have Microsoft Office installed...

Basically, I want to create a little program to simulate random outcomes for some betting models. I need to run simulations on a massive scale to test out a specific system, so I really want to be able to play around with different inputs.

Can anyone point me in the right direction here?
I tried searching Google, but didn't find much of anything helpful—plus, I'm a bit pressed for time, so figured asking here might be faster...

Thanks 👍

Is it just me, or is Microsoft Access 2010 totally tripping when it comes to alphabetical sorting, or am I just losing my mind here? Everything starting with "Ch" keeps getting lumped in with the regular "C" entries—like, "cheese" shows up way before "cherry" in the list. Is this actually normal behavior or am I doing something wrong?

Walter Watson5 said:Is it standard behavior for Microsoft Access 2010 to mess up alphabetical sorting, or am I just misconfiguring something? Everything starting with a special character seems to be treated exactly like its basic Latin counterpart—for instance, "check" is being sorted before "certain."

I would suggest checking your language settings and the specific collation settings within the database.

Anthony Perez55 said:Can anyone weigh in on this?
I tried searching Google, but I didn't find much, and honestly, I'm a bit pressed for time right now—it’s just easier to ask for help here!

So, what exactly is the "problem" here, other than the fact that you're expecting someone else to just build everything and hand you a finished Excel file? First off, you need an actual concept (and if you ask me, you don't really have one; you just have a vague notion of something, but you don't even know what you're trying to build or what you want the end result to look like). You need to grasp how data relationships work in Excel, you need to understand object-oriented programming, and you need to master Excel formulas. For starters, wouldn't it be better to just start Googling those basics? You aren't going to learn all of this overnight. Start with something simple—though, frankly, even what you've described isn't exactly easy—and once you actually get the logic behind it, move on to more complex programs. Good luck! ☕

I find myself wondering how one might best resolve this particular predicament within Excel:

In one column, I have established options for "yes" or "no"

In a subsequent column, I have a sample invoice layout situated within the range G1:H20.

If I designate a "yes" in that first column, what is the most efficient way to ensure that the invoice from the G1:H20 range appears on a different sheet automatically?

Angela Ramirez4 said:If I put "yes" in a column, how can I make this invoice located in the range G1:H20 show up on my other sheet?

Just use an simple IF function over on Sheet2.

So, say your data source is Sheet1 G1:H20, and you want it to pull through to Sheet2. Let's say you've got a "YES" or "NO" condition sitting in A1.
You want those results to pop up in B1:C20 based on whatever is in A1.
The formula for B1 => =IF($A$1="YES",Sheet1!G1,"")—then just drag that down to B20.
For C1, use => =IF($A$1="YES",Sheet1!H1,"") and drag it down to C20.

I might have missed your point here, but what actually happens when you type "NO" into A1?

Maybe try just dropping this formula into B1: =IF($A$1="YES";Sheet1!G1:G20;Sheet1!H1:H20). That way, if someone enters "YES" in A1, column B pulls the data from column G on Sheet1, but if they put "NO," it grabs everything from column H on Sheet1 instead.
Obviously, you'll need to drag that formula down from B1 to B20.

Walter Jackson48 said:Maybe I missed something, but what actually happens when you type "NO" into A1?

@Walter Jackson48/">@@Walter Jackson48, this might be exactly what he’s looking for.
It’s always like this—trying to help someone when they won't even bother making a quick sample file and uploading it so we can actually see what they need. peace.

Greetings, everyone! I have just finished printing some custom envelopes for my small business, complete with our logo and address, and now I am attempting to set up a template in Word so I can easily print recipient names and addresses whenever needed. On the surface, the task seems incredibly straightforward, yet I find myself completely unable to achieve the desired result...
Essentially, within the Mailing tab in Word, there is an Envelopes option where one is supposed to input the recipient's details and adjust the various settings. My intention is to have the recipient's information positioned in the bottom right corner, which is the standard way we handle envelopes here in the States. However, no matter how much I tinker with the settings, I simply cannot get the layout to behave itself. It either ends up dead center, upside down, or—most frequently—the printer goes through the entire motion of printing only to spit out a perfectly blank envelope... Under "envelope options," I have tried adjusting both the address position and the feed settings, but nothing seems to work.
What exactly am I doing wrong?

I mean, at the very least, they should have the decency to let us know if we actually ended up being useful to them.

mistybear522 said:I want to set up a template in Word so I can easily print out names and addresses. It looks super simple, but I just can't get it to work the way I want.

Ever thought about just using those adhesive labels? Honestly, sticking them on an envelope feels way easier. If you're interested, check out these tutorials:

- Making labels in Word 2003
- How to make adhesive labels in Word 2007
- Creating envelope labels in MS Word 2000

mistybear522 said:Hey everyone! I just had some custom envelopes printed for my small business featuring our logo and address, and now I want to set up a template in Word so I can easily print out recipient names and addresses. It seems like it should be a breeze, but I can't seem to get anything to work the way I want.
So, in Word under Mailing there's an Envelopes option where you enter the recipient's info and tweak the settings. What I'm looking for is to have the recipient's address sit in the bottom right corner, which is how we usually format them here in the States. But no matter what I try, the layout is a mess. It either ends up centered, upside down, or—most frustratingly—the printer runs through the envelope and spits out a completely blank sheet. I've been messing with the "envelope options" to adjust the address position and the "feed" setting, but nothing sticks.
What am I doing wrong?

If you're dealing with an image, you need to make sure the image wrap is set to "behind text." If it's sitting on top of the text layer, the program isn't going to let you type over it.

Betty Hayes10 said:If you’re dealing with an image and you decide to drop it into Word, you really ought to double-check whether that image is set to wrap behind the text... because if it's sitting on top, the program simply won't let you type anything at all...

I have absolutely no imagery to provide, just plain text. And regardless of how much I attempt to adjust the settings and run various tests, the text simply refuses to migrate to the bottom right corner, even though the software insists that it is positioned exactly where it should be...
Stickers could serve as a workaround, but honestly, they represent an unnecessary extra expense... I realize they aren't exactly breaking the bank, but there is something significantly more sophisticated about printing directly onto the material. I might eventually find myself forced to run everything through some heavy-duty graphic design software just to get it right...

mistybear522 said:Hey everyone! I just finished getting some custom envelopes printed for my small business, complete with my logo and address. Now, I'm trying to set up a template in Word so I can easily print out recipient names and addresses. It sounds like such a simple task, right? But for some reason, I just can't get the formatting to behave the way I want.

It might be something totally basic, but have you checked what paper size is actually selected on your printer settings (maybe it's set to A4 instead of Letter???)

Dana Diaz8 said:It might be something incredibly simple, like checking which paper size you have selected on the printer settings (perhaps Letter instead of something else???)

I’ve already adjusted those settings myself, yet it makes absolutely no difference whatsoever. It occurs to me that the issue might actually lie within the hardware itself... I happen to own a Brother HL-L2350DW, and this particular machine insists on having the paper aligned to the left side during the feeding process. When I placed an envelope flush against the left side, it pulled it in perfectly and printed without a hitch, but the moment I tried centering it toward the right, the printer acted as if there wasn't even any paper in the tray at all. It is entirely possible that the software is sending a command to the printer requesting a right-side alignment, because when I attempted to print an envelope using standard Letter-sized paper, the text positioning actually turned out quite well...
Well, now I’ve gone and made things even more convoluted for everyone 😁 The underlying problem remains unresolved....

mistybear522 said:I tried tweaking those settings too, but it didn't make a lick of difference. Honestly, I’m starting to think the issue lies within the printer itself. I have an HP Brother HL-L2350DW, and this thing insists on having the paper aligned to the left side during the feed process. When I slide an envelope over to the left, it grabs it just fine and prints perfectly; however, if I center it or nudge it to the right, the printer acts like there isn't even any paper in the tray. Is it possible the software is sending a command for right-alignment? Because when I tried printing an envelope using standard letter-sized paper, the text positioning actually came out great...
Ah, great. Now I've just gone and made things even more complicated for you. 😁 The core issue remains unresolved...

Alright, I think I see where the disconnect is. You set up a template in Microsoft Word using standard letter size, right? And since you mentioned earlier that it works perfectly when you run letter paper through—that tells me everything. To get the same result with an envelope, you have to sync what's happening in Microsoft Word with what the printer expects. Measure your envelope (if it's standard, it should be roughly 4x6 inches) and manually input those exact dimensions into your document settings. Just watch your units—Microsoft Word might be asking for inches instead of centimeters, so don't trip up there. Once that's set, try running a test print. If it still fails, then you can start wrestling with the specific Printing Options. Most likely, this is just a mismatch in paper size, and you're stuck trying to find that sweet spot between Microsoft Word and the hardware. As for the text orientation? That's on you. Run a test sheet of plain paper first to see exactly how the machine feeds it and which way the text faces—top, bottom, left, right, front, back—whatever. Once you know the "logic" of your printer, just load the envelope to match that pattern.

Dana Diaz8 said:Just run a plain sheet of A4 through first to see how the printer actually grabs the paper and which way it pops out. You really want to check where the text ends up—whether it’s top, bottom, left, right, or if it prints on the front versus the back. Once you figure out that orientation, just load your envelope exactly the same way!

Try what Dana Diaz8 suggested to figure out exactly where the text is landing on the page. Instead of just guessing how the printer handles the layout, grab a sheet of standard US Letter paper and mark it up. I usually mark both sides—for example, put numbers 1, 2, 3, and 4 in each corner on one side, and then letters A, B, C, and D on the other. Once you remember exactly how you loaded that paper into the tray, you’ll know precisely where the print hits. That way, you can position your envelopes perfectly so the addresses line up every single time. The paper size might not seem like a huge deal, but honestly, it helps to make sure your page setup in Microsoft Word matches your envelope size exactly. It makes the whole layout much easier to visualize before you even hit print.
I’ve been working on printing addresses on all sorts of different envelopes lately. I set the page dimensions to match the envelope sizes exactly, and honestly? It works like a charm. What I see on my screen is exactly what comes out of the printer. Total perfection! I’m actually using Microsoft Word for this instead of other programs, but I'm sure you'd get the same flawless results in Microsoft Word regardless. 👍

I’m still running Windows XP myself—honestly, I only keep Windows 7 around just to access this forum—but you might want to give this a shot:

Open Microsoft Word on the Windows 7 machine, head over to Mailings, then select Mail Merge, and finally hit Envelope. Inside the Envelope settings, you can pick your specific envelope size, and under Printing Options, you’ll figure out how you want to feed it into the printer. In the Feed from field, you can choose your Manual Feed method depending on how you prefer to load the envelopes; personally, I use an ML-1710P Samsung printer, so I just slide the envelope manually into the top tray, then hit OK. Once you're there, go to the bottom of the page and left-click; a text box should pop up (it looks like a little dashed outline), and that's where you type in the recipient's address. If you hover your cursor over that dashed border, the pointer turns into a little crosshair—just click and drag that box wherever you need it to sit on the envelope. After that, just hit print. That should pretty much wrap it all up.