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

Fosna, I actually tried going through the Control Panel too, but I’m getting the exact same error message. I'll give your suggestion a shot once I finally get home from work.

Fosna, I wanted to reach out and say thanks for the tip yesterday regarding Microsoft Office 2013. I went ahead and checked the Services just like you suggested—it turns out the Windows font cache service was disabled. Once I switched it over to Automatic, the whole process of uninstalling Office went off without a hitch.

Thanks again for the help, truly appreciate it.
Igor 🙂

I could really use some help or advice here. Hopefully, I'm making sense...
I’m working on a paper in Word using a bunch of different sources. Right now, I’m trying to read through one specific paper so I can pull parts of it into my own work. Is there any way to view both documents side-by-side? I don't want to keep clicking back and forth, minimizing my main document just to peek at the other one every single time...

If anyone knows a way to do this, please let me know. This constant switching is slowing me down and it's easy to lose my place...

Thanks in advance 🙂 .

casualbear17 said:I need some help and advice here, hopefully I can explain this clearly enough.
I'm working on a paper in Word using several different sources. Right now, I'm reading one specific paper that I need to finish reading so I can incorporate parts of it into my own work. Is there any way to view both at the same time? I mean, having them both on my screen simultaneously without having to constantly minimize my document just to click on the other one to read a snippet...

If anyone knows a way to do this, please let me know. Working this way is incredibly slow, and I'm losing my mind jumping back and forth between documents all day.

Thanks in advance 🙂 .

Quoting myself because I see my post was moved. Just to be clear, I wasn't just asking about Office programs. I want to be able to write in Word while reading a PDF at the same time, and so on 🙂 .

So, let's say you’ve got two documents open—maybe even more, if you're the type who likes to clutter things up like I do—and you go ahead and minimize them down to the taskbar. You hit that Minimize button, and they're just sitting there. Now, here's where you have to be careful. You right-click on an empty spot on the taskbar, then navigate to the specific card for the window you're looking at, and click on... Arrange the windows vertically, one on top of the other..

Clicking around is such a drag, isn't it? But honestly, using ALT + TAB makes everything so much smoother. It just lets you glide right between your open windows without any hassle.

Hey there!

I've got a quick question about Excel
How do I go about adding another page when I'm looking at the page breaks?

Frank Reyes said:How do I add another page when looking at page breaks?

Just select the new cell, hit Insert Page Break or just wipe out all the old ones and start fresh.

Benjamin Wilson7 said:Clicking around is just exhausting, honestly. Using ALT + TAB isn't. It makes switching between open windows feel effortless.

Let @casualbear17/">@@casualbear17 pick whatever she prefers.

Can someone please help me get this working?
In this specific range of cells, if the sum is less than twenty, I want it to just show 20. Otherwise, it should just display the actual total.
I tried tackling it this way, but I feel like I'm missing something crucial and I can't for the life of me figure out what's broken.
=IF(SUM(B3🙂6)div>

Ethan Brown58 said:Can someone please help me fix this?
In this specific cell range, if the sum is less than twenty, I want it to just show 20. If it's higher than that, it should just display the actual total.
I tried playing around with this formula, but I feel like I'm missing something crucial and I can't for the life of me figure out what it is.
=IF(SUM(B3🙂6)<20;"20")

You're missing the third argument—basically, you need to tell the formula what to do when the condition isn't met, which in this case is to just show the sum.

Code:

Ethan Brown58 said:Can someone help me out with this?
If the sum in this cell range is less than twenty, I want it to show 20. If it's more, just show the actual total.

Look, when you're messing with nested functions in Excel, you gotta follow the syntax rules for all the arguments.

The syntax for an Excel IF function goes like this:

Code:

Basically, you're missing an argument.

If you nest a SUM function inside an IF function, you have to finish out that SUM argument properly.
So, your formula should look like this:
Quote:

=IF(SUM(B3: B6)td>

BTW: check this link for Excel functions with their full syntax and arguments.

[EDIT]: my bad frozenheron7, you already answered while I was typing.

Kyle Johnson2 said:[EDIT]: my bad, frozenheron7, you beat me to the punch and already answered

No big deal. I handed him the fish, but you’re the one who actually taught him how to fish. 😉

My professor just went over my term paper and told me I need to fix up the Table of Contents, but I'm honestly feeling a bit lost on how to actually do it. He gave me some specific notes on what needs changing—I've attached an image here so you can see exactly what he's looking for. If anyone knows the right way to handle this, please help! 😢 😢

http://upload.slike.com/slike/2014/0...x-52px-121.jpg

http://www.hichert.com/images/storie...ncials_800.jpg

Greetings.

I am struggling with the specifics of this Chart. Specifically, I am having trouble implementing the small bars alongside the lines, ensuring the values align correctly with their respective sides, and applying a two-color conditional formatting scheme.

Could someone assist by setting up the core components and uploading an XLS file for me to review?🙂

Henry Lewis37 said:that whole bit about the tiny bars, the lines, and making sure the numbers actually stay on the same side as the bar itself.

Look, you're basically asking for a full syllabus here. A Chart in Excel can get pretty hairy for beginners once things get even slightly complicated. You gotta nail the basics of how to build a Chart first.

- Chart in Excel 2003
- Chart in Excel 2007

Then just Google "negative value on Chart data Bar"

- Positive - Negative-Value-Chart-by-Ozgrid
- Data Bar Improvements in Excel 2010

Can I get some advice here?
A few days ago, some IT guys came by my office to install an antivirus program, and right as they were doing it, the system crashed (we were running Windows XP at the time). The same technician took the computer to the service center and did a fresh install of Windows 7. Now, I’m trying to get back to work in Word, and I’ve hit a massive wall. It’s nothing fancy—just a standard table—but whenever I try to copy something from elsewhere (which is a huge part of my workflow) and then attempt to undo the action using that blue arrow at the top (you know, the "undo" command, Ctrl+Z), everything just freezes. The cursor turns into that spinning hourglass icon and stays stuck there for an hour without doing a single thing.
Is it possible that when the system crashed during the Windows update, it corrupted the file itself? This specific table is for the 2014 records, but honestly, none of my files from previous years are working right either; they all act the exact same way.
If anyone has any ideas on what might be causing this, please let me know. Thanks.

🙂

Kyle Johnson2 said:When you're messing around with nested Excel functions, you really have to play by the rules regarding syntax arguments. If you miss one, the whole thing falls apart.

The standard syntax for an Microsoft Excel IF function looks like this:

Code:

=IF(logical_test;value_if_true;value_if_false)

Basically, you've left out one of the required arguments.

If you decide to nest a SUM function inside an IF function, you need to make sure that the SUM argument is fully completed.
Your final formula should actually look more like this:

BTW, I dropped a link here for Excel Functions including syntax and arguments

[EDIT]: Sorry JohnColtrane, you beat me to the punch and already answered him while I was typing this up.

Thanks.

Kyle Johnson2 said:I will provide a list of questions. Creating a Chart in Excel can be quite a steep learning curve for beginners once you move past the basics. You really need to master the fundamentals of how to build a Chart first.

- Chart in Excel 2003
- Chart in Excel 2007

From there, try searching Google for "negative value on Chart data Bar."

- Positive - Negative-Value-Chart-by-Ozgrid
- Data Bar Improvements in Excel 2010

None of this helps me even slightly, but fine, thanks for the effort.

Best regards,

Hey, I could really use some help here. I’m looking at one of those software bundles and man, the price tag is pretty steep, but I actually need several of them for my office setup. I'm just wondering how the whole thing works—do I have to buy a separate license for every single computer, or is there some kind of bulk discount available if I'm buying more than one?