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

Good morning!

I’m currently staring down a bit of a mountain in Microsoft Office—I need to merge several different documents into one single, cohesive file.
To make things a little more manageable during the drafting process, I kept them separate since the total length is hovering around 350 pages.
But now that it’s time to bring them all together, I’m facing a total nightmare. Every individual document has its own specific formatting, and once they touch, everything falls apart. Page numbers go haywire, table fonts shift unexpectedly... it's just absolute chaos.
Is there any way to prevent this mess? Can I use sections within the document to act as buffers so they don't "bleed" into one another? Ideally, I want each part to hold onto its original settings without interfering with the rest.

Thanks in advance for the help!

Drew Bennett68

Dana Diaz8 said:0.123456789 => I use the TRUNC command to keep five decimals => 0.12345, but now I want that last digit to be a 6 instead of a 5, since it really ought to round up to the higher value 🙂)

Look, if you’re just looking for standard rounding, the ROUND function does exactly what you need—it's pretty straightforward. If you're aiming for some specific, non-standard logic, then you'll need to be a bit more descriptive about what you're actually trying to achieve. 🙂

Walter Jackson48 said:=IF(MOD(B166*100,100)=75,TRUNC(B166)+0.5,ROUNDUP(B166/0.5,5)*0.5)

What exactly is this formula supposed to be doing? 😕

Drew Bennett68 said:I suppose I simply have to. If you find yourself staring at several disparate documents and realizing they all need to be merged into one single, cohesive file within Microsoft Office—well, I suppose there are a few ways to tackle it, though none of them feel particularly elegant. It’s a bit of a chore, really. One could, I guess, just copy and paste everything manually, but that is a recipe for disaster if you care about formatting—which, let's be honest, most people don't until it's too late. A more... deliberate approach would involve using the "Object" function found under the "Insert" tab. You basically tell the software to pull the contents of those other files directly into your master document. It’s somewhat efficient, provided your styles aren't a complete mess. Otherwise, you're just inviting a headache.

Why on earth would anyone even ask that? I mean—really—what is there to say? It’s such a broad, sweeping question that it almost feels like a trap, or perhaps just a symptom of the general lack of direction we see everywhere these days. I suppose I could attempt to unpack the layers of whatever specific situation you're implying, but without any context, it's all just guesswork on my part. Maybe you're looking for a deep philosophical breakdown, or maybe it's just a momentary lapse in thought—but honestly, without more detail, I'm just staring at a blank wall here. 😕

If you’re dealing with pagination issues, I suppose the simplest fix—and honestly, probably all you really need here—is to just manually set the starting page number in each individual document to whatever you want it to be. There are certainly more sophisticated, automated ways to handle that workflow, though I highly doubt you'd find them necessary given the circumstances.

You could potentially develop a separate set of content—then just manually copy and paste it wherever you feel necessary—though I suppose there is a more "intelligent" way to handle that process, if you really want to get technical about it. Not that you necessarily need to, of course.

Justin Torres77 said:"Your" formula—you know what I mean, b.i.t.c.h. 😁

What I was actually trying to get at is that I’m completely washing my hands of this whole formula—mostly because of that number four. 😁

Drew Bennett68 said:Good morning!

I need to merge several different documents into one single master file using Microsoft Office.
The thing is—I split them up originally just to make things easier to manage, since the whole mess totals about 350 pages.
Now that I’m trying to pull them all together, it’s a total nightmare—every document has its own settings, so the page numbering goes haywire, table fonts shift everywhere... basically, it's absolute chaos.
Is there any way to avoid this? Can I use sections within the document so they don't "bleed" into each other during the merge—basically keeping each part's formatting intact?

Thanks in advance!

Drew Bennett68

Just stick to the classic copy/paste method. Go to the end of your current document, drop in a section break, and then paste the next document right there. If you try to use "Insert File" or some fancy merge function, the formatting is going to be a complete disaster.

Kimberly Smith69 said:how though?

Not sure if I'm too late here, but if you haven't figured it out yet, just check a tutorial.

- File association

Drew Bennett68 said:I need to merge a bunch of different files into one single document in Word... Is there a way to stop them from messing each other up? Like, can I use sections so each part keeps its own formatting when I combine them?

Just merge everything and throw a new section break in for every file.

- Working with sections in Word

Justin Torres77 said:So I just copied all the duplicate numbers into different columns to slim down the spreadsheet. Mine's over 700 rows long

Personally, I’d just stick with SUBTOTAL for stuff like this

Benjamin King2 said:Maybe try the old-school copy/paste approach—just head to the very end of your document, insert a section break, and then paste the next file right there...

The thing is, a section break alone isn't going to stop the text from getting reformatted.

The real issue here—and I say this quite dispassionately—is that people tend to build massive documents using "manual" formatting instead of actually being consistent with Styles. When you do that, it's almost inevitable that you run into these kinds of headaches.

Walter Jackson48 said:If your base value is sitting in cell B166, try running this formula:

=IF(MOD(B166*100,100)=75,TRUNC(B166)+0.5,ROUNDUP(B166/0.5,5)*0.5)

It doesn't actually work 😕 or maybe I just don't know how to use it 🤷

Dana Diaz8 said:it just isn't working 😕 or maybe I just don't know how to use it 🤷

Honestly, I can't even wrap my head around what this formula is actually supposed to accomplish.

Let me ask you one more time: if all you need is basic rounding—in which case, you should probably just be using the ROUND function.

Nicholas King said:I honestly have no clue what that formula is even supposed to accomplish.

Let me ask you one more time: if you just need basic rounding, why overcomplicate things? Just use the ROUND function.

Bingo. That’s the one! 🙏

Nicholas King said:I honestly have no clue what this formula is even attempting to accomplish.

Once again, I find myself asking: do you just need basic rounding? Because if that's the case, there is a perfectly functional ROUND function sitting right there in Excel waiting for you to use it.

Looking at this specific formula through the lens of standard rounding rules, it’s actually bumping that fifth decimal place up. If your goal is to force the number down instead of using ROUNDUP, then you should be using ROUNDDOWN. In my own sheet, when I plugged in the value from the prompt (0.123456), the formula rounded it up to 0.12346)

p.s. Just to be crystal clear—if you want to round down rather than up, go with ROUNDDOWN.

Quick Outlook question
I can receive emails just fine, but I'm completely blocked from sending anything.
It works perfectly on my other computer—sending and receiving are both totally fine there.
I keep getting this specific error message (check the screenshot)
Any idea where the issue might be lying?

Walter Vaughn4 said:I can receive emails just fine, but I can't send them at all
whereas on my other computer, everything works—sending and receiving without any issues.

Are you absolutely certain that the SMTP settings are identical on both machines? It seems to me—and I could be wrong here—that something hasn't been configured quite right on the one giving you trouble.

Walter Jackson48 said:This particular formula—if you follow standard rounding rules—actually bumps the fifth decimal place up by one for certain values.

If you’re looking to force that fifth decimal place to round up more aggressively, I guess using CEILING(A1, 0.00001) might do the trick—it would take something like 0.123454 and push it up to 0.12346, though, mind you, it would leave a number like 0.12345 exactly as it is.

Now, if you just want "standard" rounding, then I suppose you should probably just stick with ROUND.

Dana Diaz8 said:Yes! Exactly! That's the one!!!!!! 🙏

Maybe just head over to John's place quickly and get a proper start on Excel. 🙂

I’m being dead serious here—if you don't, you're just going to waste your time and blow your nerves, and you'll never actually be certain if everything is functioning the way it's supposed to.

Hey everyone!

So, I’m currently neck-deep in drafting a questionnaire for my senior thesis, and I’ve decided that instead of just letting people type out their answers like it’s 1995, I want to use those little radio buttons to keep things organized. The problem is, I’m staring at the screen wondering where on earth they're hiding. Does anyone actually know how to get those to show up in Word? Like, what’s the trick to inserting them?

Thanks a bunch,
☕🤷
🤷

Nicholas King said:Are you absolutely certain the SMTP settings match on both machines? It seems like something might be misconfigured on the one causing trouble.

How am I supposed to manage that? Do I need to physically go somewhere? I guess I'll have to find where all that info is located on one PC just to copy it over to the other.

Alexander Thompson83 said:I'm working on a survey for my senior thesis, and I want to include those little radio buttons—but I have no clue how to actually do it. Where are they even located? How do you insert them into Word??

Honestly, if I were you, I'd look into building the forms in a PDF instead—it might be a much cleaner option. Though, I suppose you weren't exactly being very descriptive about the issue you're facing. 🙂