Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Monthly Archives: June 2016

Subscribers: Formatting, Formatting, Formatting!!!

Posted on by Posted in Subscribers Word 2013

Just about every e-mail I get requesting help in MS Word, involves formatting.  So, for that reason I thought I would do a little refresher course article - a cheat sheet if you will - that you can print and keep for future reference.  Don't get me wrong, I do not mind helping anyone -

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

It’s nice to Take a Break…

Posted on by Posted in Carol's Ramblings

I do love publishing my newsletter, and knitting for charities and working in general, but I do relish those little windows of time where I get to decompress and do things at my own whim, instead of following a schedule.  You, know, wait to be inspired before I have to write something and taking my time while I do it, or taking a brisk walk because I feel like it, at my own pace, instead of doing it just to stay healthy.  You get the idea.

Having said that, I am going to seize that very opportunity in a few short days.  I will be taking myself to the seashore along with my daughter, son-in-law and the grands.  Will it be slow and doing things on my own schedule?  Absolutely not!  But it is sure to be loads of fun and a time to recharge my batteries.  Any time spent with my grands is good time!

I hope you all get a chance this summer for a brief respite from your daily duties and obligations and get to do things just because you feel like it – not because you have to.

Whatever you get to do, make sure you are kind to each other and help others when you have the opportunity. Let others know how you feel about them too – it will make you feel good as well.

Until next time, take care of you!

Carol-signature

How to Open Multiple Documents at Once in Word

Posted on by Posted in Uncategorized, Word 2013

You can quickly load multiple documents in one easy step because Word provides a feature to do that that .

Follow the steps below to learn how:

  1. Open the Open dialog box by clicking Ctrl+O. If you are using Word 2013, you’ll also need to click Computer | Browse after pressing Ctrl+O.)
  2. Rather than double-clicking on a file name, start to create a selection set. If you are selecting sequential files, click on the first file in the sequence, then hold your Shift key as you click on the last. You can add additional files to those selected by holding down your Ctrl key while clicking with the mouse.
  3. To remove files from the selection set, hold down the Ctrl key while clicking on a file name you previously added to the set.
  4. When you are finished with your list, click Open.

Look around and explore in the Open dialog box. You will find it has many of the same options as Windows Explorer as well as a few more. Pay particular attention to the options available on the drop-down list displayed from the Open button (click the down arrow at the right of the Open button).

How to Set Default Attributes for Lines & Arrows in your Worksheets

Posted on by Posted in Uncategorized

If you adds lines and arrows all the time to flowcharts that you creates in Excel, you may be wondering if there is a way to set a default line weight, color, and arrowhead. Turns out there  is!

Follow the steps below:

  1. Draw your line or arrow as you normally would.
  2. Format the line or arrow so that it appears just as you want it to.
  3. Right-click on your line or arrow to display the Context menu.
  4. From the Context menu select Set Default Line.

Now,  your lines and arrows will be drawn using the formats you made the default for the rest of your current worksheet!

How to Get Rid of Empty Rows in an Imported Worksheet in Excel 2013

Posted on by Posted in Excel 2013

There are times when you have to work with data in a worksheet imported from another program into Excel.  Normally, it is not a problem to import the worksheet. The problem is that during the process potentially hundreds of extra rows that have no data in them are imported as well. After the import you have to manually delete those extra rows so you can use the rest of the data. So is there is a way to easily get rid of these empty rows?

There are different  ways you can look at this. The easiest way could be to simply sort your imported data by the column of your choice. All the rows that contain nothing in that column end up at either the end or beginning of the data (depending on if you sort in ascending or descending order) and you can easily delete those rows.

When you do a sort in this manner though, you could easily end up with your data out of the original, imported order. If you need the data to be in the original order—but with the blank rows removed— you can just insert a column to the left or right of your data, fill it with sequential numbers, do your sort by any column except that added column, and then delete the rows that are blank (with only something in the numbering column). You can then sort a second time based on the numbering column and your data will be back in its original order. Seems a tad tedious don’t you think?

Follow the steps below:

  1. Select your entire column.
  2. Click F5 to display the Go To dialog box.
  3. Click Special to displays the Go To Special dialog box.

Go To special

  1. Select Blanks | OK. Excel selects only those cells in the column that are blank.
  2. Select Delete from the Edit menu to display the Delete dialog box.
  3. Select Entire Row and then click OK.

Subscribers: How to Create A Reference Page and Citations in Word 2013

Posted on by Posted in Subscribers Word 2013

First, you want to create  Bibliography in word. Follow the steps below to learn how: Click the References tab on your Ribbon. In the Citations & Bibliography group, click Manage Sources. Either copy sources from the Master List to the Current List or create New sources that will automatically be added to both the Master

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: Get to Know Your Animation Pane in PowerPoint 2013

Posted on by Posted in Subscribers PowerPoint 2013

The Animation Pane in PowerPoint allows you to view and manage the effects that are on your slide. You can modify and reorder your effects directly from the Animation Pane which is extremely useful when you are using more than on effect. Follow the steps below to learn how: From the Animations tab, click the

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: How to Have Rounded Corners on Text Boxes

Posted on by Posted in Subscribers Word 2013

When you use the Text Box tool on the Insert tab of your ribbon, Word will allow you to draw a text box anywhere in your document. This text box is always rectangular, but suppose you want to create a text box with corners?? Word really does give you a lot of control when it

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: How To Insert Your Document Title Into Your Document

Posted on by Posted in Subscribers Word 2013

Word knows lots of facts about your documents. Did you know that? Well, it absolutely does. If you would like to see what information is store by Word, follow the steps below: In Word 2007, click the Office button and Word Options, when the dialog box displays, select Prepare | Properties. In Word 2010 or

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: How to Change the Spacing Between Your Footnote and the Separator line in Word

Posted on by Posted in Subscribers Word 2013

As most of you already know, when you insert a footnote into your text in your Word document, it gets added to the bottom of your page by default and it is accompanied by a short line and an blank paragraph to separate it from the body of your document. The footnote and it's separator

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!