Categories
Carol's Ramblings

Happy Valentine’s Day!

I hope you enjoy a lovely Valentine Day with your sweet patootie and if not, celebrate it with whomever you like!  Celebrate is the key word here so have at it.  Eat some chocolate or have a hot chocolate or a sweet of your choice.  Or you could have a good meal – something you do not ordinarily have!  Just make the day special for YOU are special.  Remember, there is only one of you in this whole wide world!

We are having record cold temperatures in my little corner of the world.  I think the high tomorrow is supposed to be 17 degrees and the winds are to be at up to twenty miles per hour making the wind chill index in the minus number category!  So I think I will just be staying indoors tomorrow with hot cup of tea or coffee and reading or knitting after I finish my chores.  I keep telling the cat how lucky she is to be inside!

Speaking of the outdoors and record cold temperatures, please try to be kind to the homeless.  If you see a homeless person on the street corner, give them a pair of gloves or a scarf to keep themselves warm or give them some money to get a hot meal.  We never know what is in store for us and so try and be compassionate to those who are worse off than you.  You can never go wrong following the golden rule!

If you have a bird feeder, fill it up because the poor creatures cannot eat if the ground and trees are frozen!  Remember to keep your animals sheltered as well.

I hope the articles I have written this month are helpful to you and that you learn something from them.  If you have a tip or trick that you use all the time, please share it with me and I will give you credit for it in an article.

Oh yes, I have been very busy with knitting as well…two scarves a couple of hats, etc.  I like to keep busy!

Until next time, take care of yourselves and be kind to each other.

Carol-signature

Categories
Outlook 2013

How to Assign a Category to an Item in Table View in Outlook

Assigning color categories to items in your Inbox or other table views is similar for all Outlook items and assigning color categories in card view in Contacts or Icons view in Notes is the same as assigning color categories in Table view.

Follow the steps below to learn how to assign a color category:

  1. Select the item.
  2. Click the Categorize button on the short-cut menu.

Categorize button

  1. Click a color category.
  2. OR
  3. Right-click your item, point to Categorize button on the shortcut menu.

Categorize button

  1. Click a color category.

Only the most recent 15 color categories will appear on the Categorize menu. To see more or to create a new category, click All Categories. To assign a color category from the color Categories dialog box, you must select the check box next to the color category.

In Timeline views (i.e., those offered in Tasks and Journals), the only method to assign a color category to the item is to use the shortcut menu described above.

  • For Journal view, the Categorize button is not displayed on your toolbar by default. To add the button:
  • On the Tools menu, click Customize.
  • On the Commands tab, in the Categories list, click Actions.
  • Int he Commands list, click Categorize and drag it to your toolbar where you would like it to appear.
Categories
Subscribers Excel 2010

How To Remove Hyperlinks In Excel Without Using a Macro and Leave the Text

This is a quick and easy way to remove hyperlinks in your worksheet without the fuss and bother of a macro. You will not believe how easy this is to do! Follow the steps below to learn how: In a blank cell in your worksheet, key in the number 1. Select your cell and click […]

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!
Categories
Subscribers Word 2013

Subscribers: How to Start Chapters on Odd Numbered Pages in Word

Word will allow you (IF you use styles) (and I sincerely hope you do), to force your headings to begin on a new page. But suppose you want your heading to begin on an odd numbered page? As you know from previous articles, you can insert section breaks that will force your next heading to […]

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!
Categories
Subscribers Word 2010

Subscribers: How to Use Multiple References to the Same Footnote in your Document

I don't know about you but when I am working on a document for someone they seem to think I know everything there is to know about Word (which certainly is not the case) and seemingly think I can make it happen immediately! I remember once I was asked to use multiple references to the […]

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!
Categories
Excel 2013

How to Round to the Nearest Half Dollar in Excel

When you are working with data that involves money and finances, you often need to round amounts to a specific point such as a dollar or perhaps even a half dollar.

The tried and true method has always been to use the ROUND function with a formula like the one below:

=ROUND(A26/0.5,0)*0.5

The formula divides the value in A26 by half a dollar (0.5) and then rounds it to zero decimal places. The value is then multiplied by 0.5 to get it back to the form you want. If you prefer not to multiply and divide by decimal amounts, you can use the method below:

=ROUND(A26*2,0)/2

But, an even better method would be to use the MROUND function. This function will round a value to any multiple that you specify.

In the case at hand, if you would like to round the value in A26 to the nearest half dollar, you would use this formula:

=ROUND(A26, 0.5)

Categories
Subscribers PowerPoint 2010

Subscribers: How to Insert Screen Clips in your PowerPoint Presentation

Both PowerPoint and word make it extremely easy to insert screen clips. All you have to do is select Screenshot from the Insert tab on your Ribbon! It will then launch a gallery of of windows you currently have open. You can click one to insert an image of the window into your document or […]

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!
Categories
Subscribers Word 2013

Subscribers: How to Cross Reference to An Automatic Number in Word

When I say Automatic Number I mean using a field for a number in your document.  I am sure that there are lots of folks out there that use these in Academia and legal fields, insurance companies, realtors, etc. For instance, suppose you have a paragraph numbered Clause 2.2, but you want your cross reference […]

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!
Categories
Subscribers Outlook 2013

Subscribers: Tips, Tricks and Shortcuts for Outlook 2013

Whether you are crazy about Outlook or not, it is the preferred e-mail software used in offices around the world. As such, it would behoove you to learn all you can about this robust piece of software.  After all, why wouldn't you want to save time and keystrokes and be as efficient as possible? I […]

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!
Categories
Subscribers Word 2010

Subscribers: How to Split a Document in Word 2010

I have a little confession to make in regard to this article.  It isn't always easy for me to decide what I will write about but eventually I settle on something because there is so much to choose from.  But, sometimes, as in this case, I am absolutely inspired.  Necessity, as they say, is the […]

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!