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

Hey everyone. I’ve put together an online template for an electronic business card, and I was wondering how I might go about sending it so it displays immediately upon arrival in someone's inbox, rather than just sitting there as a standard attachment. My goal is to lock down all the text so that whoever opens the email sees nothing but the template itself... I’d really appreciate some help with this.
Just as a quick heads-up, I built the template using Word, which is why I decided to post this here. Best to you all.

Need some Excel help

In column A, I have a fixed list of numbers from 1 to 30. These stay the same.
In column B, I want to enter any 5 numbers that I can change whenever I need—for example: 2, 6, 11, 16, 19.
I need column C to automatically show all the remaining numbers from column A in order: 1, 3, 4, 5, 7, 8, 9, 10, 12, 13, 14, 15, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30.
Which function should I use?
Thanks a lot for the help!

Here’s an idea I’ve been chewing on—feel free to take it, tear it apart, and make it something actually useful:

So, I set things up in A1:A30 by typing in numbers from 1 to 30. Then, in B1:B5, I just threw in a few random numbers from that same 1:30 range. To tie it all together, I dropped this formula into C1:
=IF(AND($B$1<>A1:A30;$B$2<>A1:A30;$B$3<>A1:A30;$B$ 4<>A1:A30;$B$5<>A1:A30);A1:A30;""), then I dragged that whole thing down through C30.

Robin Fowler4 said:thanks a ton for the help

If that fix from @Walter Jackson48/">@@Walter Jackson48 doesn't cut it, check out these tutorials

- Finding unique values between two columns in Excel (stuff in A but not in B)
- Lottery stats in Excel
- Lottery combinations in Excel

Walter Jackson48, thanks a ton for fixing this!!!!
Thanks too, Kyle Johnson2, I'll check out this tutorial page later on. 😉

Thanks so much!

Does anyone happen to know how to force the graph curves to actually start from the origin?
I was trying to put together a chart in Microsoft Word—just a simple one, really—but no matter how much I tweak the x and y values, the curve refuses to touch the zero point. I honestly can't figure out where the catch is...

If anyone could point me in the right direction, I’d appreciate it. It’s kind of urgent. Help!

Wait, what exactly are you trying to pull off here?

Microsoft PowerPoint is actually pretty decent if you just need to show some basic charts.
I haven't really messed around with Microsoft Word for this kind of stuff—never used it that way, honestly.
Then again, you could always just whip something up in any random graphic design app... I mean, why not?

If this is for a website or something, there's Google Charts.
https://developers.google.com/chart/
But yeah, you’re gonna need someone who actually knows their way around JavaScript to get that thing running properly.

There are also a ton of those online chart generators out there that do a surprisingly good job.
http://www.onlinecharttool.com/

William Miller83 said:What exactly are you trying to accomplish here?

Microsoft PowerPoint handles charts reasonably well enough.
As for Microsoft Word, I haven't really messed with it much myself—so I can't say for sure.
Then again, you could always just manually plot it in some kind of graphic design software.

If this is for a website, there’s Google Charts.
https://developers.google.com/chart/
Though, you'd probably need someone who actually knows their way around JavaScript to set that up for you.

There are also plenty of online chart generators out there that do a decent job.
http://www.onlinecharttool.com/

It's for my thesis. And yeah, I suppose you could use Microsoft PowerPoint. But the issue is that whenever I input the values, the curve starts right at that specific data point—it won't start from zero, or rather, the origin. Which is how it's supposed to look. 😢

So, just in case it wasn't crystal clear—I am simply looking for a basic line graph to track some values. I used to handle this in Microsoft Word by heading over to the insert charts menu, selecting the X Y scatter option, and then manually plugging in the data. For instance, if I set x as 2, 4, 6, 8 and y as 4, 6, 10, 13, I get my curve. My only real issue is that I need the line to actually start at zero—you know, from the origin point on the chart. Does anyone have a fix for that?

Grace Thomas said:I just wish it would start from zero, you know? Like, using the actual origin on the chart. Anyone?

Check out this tutorial and the links at the bottom—might help you out.

- Microsoft Excel charts

Grace Thomas said:So, just to clarify, I'm looking for a simple line graph for some data points. I used to do this in Microsoft Word by going to Insert > Charts and picking the X Y Scatter option, then plugging in my values. For example, x: 2, 4, 6, 8 and y: 4, 6, 10, 13. That gives me a curve. The thing is, I really want the line to start from zero—from the origin point on the chart. Anyone know how?

The graph won't start at zero unless you actually give it a zero value. In your case, you'd need to start the x-axis at 0 (0, 2, 4, 6, 8)...

And if you want it to hit the origin perfectly, that first y-value also needs to be 0 (0, 4, 6, 10, 13)

ruggedcyclist7 said:The graph won't start from zero unless you actually set those values to zero—so in your case, you really need to have the x-axis start at 0 (like 0, 2, 4, 6, 8).

If you want it to look like it’s coming directly from the origin, then your first y-value has to be 0 as well (0, 4, 6, 10, 13).

Well, thanks, it's working now. 😁 I actually tried doing it your way yesterday, but for some reason, it just wouldn't cooperate. 🤷 It's entirely possible I mistakenly selected a standard "line" chart instead of an x-y scatter plot, which probably explains why it failed—standard line charts usually require a bunch of extra tweaking. With all the different settings available, who knows what I missed.

So, I went back to that "line" option, and even after entering the zeros, it still wasn't hitting the origin quite right. However, I did figure out that you have to check the "On tick marks" box in the position axis settings.

Kyle Johnson2 said:Maybe take a look at this tutorial—and the links at the bottom might actually be useful if you're lucky.

- Charts in Microsoft Excel

Hey, thanks for the page, but I actually managed to sort out the issue already. I’m definitely no expert when it comes to Microsoft Excel—I guess I could probably figure some things out by poking around the site—but I just didn't have the time to mess around with it right now.😁

Hey everyone,
I’m running into a bit of a wall with some logical functions (the whole IF, AND, OR thing) in Microsoft Excel. I've got this specific scenario where I need two different sets of conditions to trigger a result. Basically, I want the cell to say YES if either Column A >= 10 and Column B >= 2, OR if Column A >= 15 and Column B >= 3. If neither of those situations is met, it should just say NO.
So, I tried putting together this formula: =IF(AND(A3>=10;B3>=2;"DA");OR(IF(AND(A3>=15;B3>=3);"DA";"NE")))
But, for some reason, it keeps spitting back an error—specifically, I'm getting that annoying #VALUE! message.

Any chance someone could help me figure out what I'm doing wrong?

Best,
S.

Timothy Reed7 said:Hey everyone,
I need a little help with logical functions (like IF, AND, and OR) in Excel. Here is my situation: I have two different sets of conditions that need to be met. For example, either Column A >= 10 AND Column B >= 2, OR Column A >= 15 AND Column B >= 3. If one of those pairs is true, I want it to say YES, otherwise NO.
I tried typing in this formula: =IF(AND(A3>=10;B3>=2;"YES");OR(IF(AND(A3>=15;B3>=3);"YES";"NO")))
But for some reason, I keep getting an error message: #VALUE!

Thanks so much for the help,

Best,
S.

=IF(OR(AND(A1>=10; B1>=2); AND(A1>=15; B1>=3));"YES";"NO")
Just take a close look at how the parentheses are nested and how the conditions are checked.
The AND functions handle each pair separately, then the OR checks both of those results, and finally, the IF evaluates everything inside the brackets.☕

Give this formula a shot, assuming we're on the same page here:

=IF(OR(AND(A3>=10;B3>=2);AND(A3>=15;B3>=3));"YES";" NO")

p.s. I see one of my colleagues beat me to the punch; I completely missed his post earlier.

I am currently using Word 2003. I have finished my final thesis, which includes a massive amount of images. My goal is to get this printed, but every time I take the file to a print shop and they open it in Word 2010, the entire layout falls apart 🙂
. I attempted to convert the file to a PDF on my own computer, but I ran into the exact same issue. Please, I need some assistance immediately: is there any reliable way to print this document so that everything remains exactly as I formatted it in Word 2003? There is far too much content here; surely there isn't any other option besides me manually reformatting everything in Word 2010 😢?

Sophia Thompson41 said:Is there any way I can print this document so that everything looks exactly the way I formatted it in Word 2003?

Try downloading a PDF writer (most are free). It works like a PDF converter, but you actually install it on your computer as if it were a physical printer. You can tweak all the settings just like any other printer you have plugged in, but the end result is just a PDF file saved to your hard drive. Once you have that, you can take it to a print shop and you shouldn't run into any issues. If that doesn't work, then honestly, you probably didn't get your image alignments right in the first place!

Greetings,

I’m using the English version of Microsoft Office Outlook 2007 for my emails.

I need to find where the setting is to stop the program from automatically capitalizing the first letter of a sentence whenever I hit Enter to start a new line while drafting an email.
Can someone walk me through the exact steps to disable this?

Thanks in advance for any help regarding this issue.

@Dana Diaz8/">@@Dana Diaz8: It worked perfectly. I really appreciate the help. 😘