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

Carol's Corner Office

Monthly Archives: May 2015

Subscribers: How To Join Text and a Number in an Excel Formula

Posted on by Posted in Subscribers Excel 2010

In many cases you can use the Ampersand symbol (& - what most folks call the "and" sign) operator to join text with a number in your formula. If you want to combine text with the results of a formula in a cell you use Concatenation. Suppose you have calculated a range of cells using

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 Use the GotoButton Field in Word Documents

Posted on by Posted in Subscribers Word 2013

One of the fields that ships with Word is one that will simulate the Go To command. As you all know, the Go To command springs to life when you click F5 or CTRL G. This particular feature will allow you to define a field that will appear as a button in your document. If

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 Define a Single Condition in Excel

Posted on by Posted in Subscribers Excel 2010

There is a very powerful feature that comes with Excel that will allow you to format the contents of a cell based completely on conditions that YOU specify. Of course, this is called Conditional Formatting. When you decide to use conditional formatting, it's all up to you and whether you want to define a single

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 Save Time and Everything Else in PowerPoint 2010

Posted on by Posted in Subscribers PowerPoint 2010

I like to think I know my way around PowerPoint pretty well and I used to think I was pretty savvy. But I recently learned some really cool tips that turned my PowerPoint experience upside down! I was so blown away by these tips that I knew straight away that I had to share them

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 Do Page Counts for Multiple Documents in Word 2013

Posted on by Posted in Subscribers Word 2013

Suppose you have a folder containing two or three hundred Word documents.  If you are like me, that is not such a fantastic amount. In any event, suppose also that you would like to print a list of those documents and the page count for each of them. I never knew how to do this,

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!

Word Keyboard Shortcuts

Posted on by Posted in Word 2010

I have been asked many times about keyboard shortcuts.  It seems that folks do actually read what I write about and take note of the shortcuts I use.

Microsoft Support has a page listing the keyboard shortcuts for Word 2003, 2007 and 2010. I know that this will be invaluable to a lot of you and will save you untold time and keystrokes in the future.

You can find the shortcuts here.

Also below is a handy Excel Workbook with different pages for different equivalent commands.

Equivalent Commands

You’re welcome!

Finally, Warm Weather!

Posted on by Posted in Carol's Ramblings

We have been having some lovely summer type weather in my little corner of the world and I have really been enjoying it.  It’s so nice to get outside again!

We just celebrated Mother’s Day here. I’m not sure if it is celebrated everywhere but I believe it to be a nice holiday.  I spent the entire day with my children and grandchildren and what could be better than that?

I hope all my female subscribers were able to enjoy a nice Mother’s day as well!

I know I have said it before, but if you have something in particular that you would like me to cover, please let me know and I will do my best to accommodate you.  Alternatively, if you have something that works for you please feel free to share it.  I am always looking to save time and keystrokes as you all know.

It’s going to be a busy summer for certain.  The older I get the more quickly time flies!

Please remember to be kind to others and take care of yourself too. Until next time…

Carol-signature

Subscribers: How to Prevent Automatic Hyperlinks in Excel

Posted on by Posted in Subscribers Excel 2010

Hyperlinks are great! I love to use them and I sometimes use them in Excel. Hyperlinks can be very useful in your Excel worksheet (i.e., links to data, other workbooks, documents, Websites, e-mail addresses, etc.) Even though hyperlinks are often useful in your worksheets though, it can be downright aggravating when you enter data (i.e.,

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 Turn Off Color When Printing in Word

Posted on by Posted in Subscribers Word 2010

When you have a document with multiple comments (i.e., technical writing, academia, etc.) on multiple pages it could use up a lot of colored ink when you print said document.  We all know that color toner and ink is not inexpensive so it would behoove us to print in black and white when we can.

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 Format Comments in Word 2013

Posted on by Posted in Word 2013

Once you have added a comment to your document, Word will display that comment in a number of ways, depending on how you have configured your licensed copy of Word.

Having said that, the mainstay of Word is to keep the display as straightforward and easy as possible. You can, if you like, display your comments with a little more flair.

  1. You can format the text in your comment as you would format any text.  You simply need to select the text in your comment and then avail yourself of the tools on your Ribbon to format with the font of your choice, bold, italics, etc.
  2. You can also right-click any text you have selected and choose Font to make even more details edits.

Please note that the basic formatting of comments in word is determined by Word Styles such as the the ones below:

  • Comment Reference:  This style controls the formatting of any comment references within the boy main body of your text.
  • Comment Text:  This style controls the formatting of the text used to print your comments. This only has importance when you choose to print a list of markup.
  • Balloon Text:  This style controls the formatting of the comments when they appear in balloons, regardless of whether they are displayed or printed.

If you choose to modify these styles, the formatting of your comments will be changed accordingly!