Categories
Carol's Ramblings

Spring has Sprung – Sort of…

Yes, I know Spring has not officially started, but as I have stated many times in the past, despite what the calendar says, Mother Nature lets me know when Spring is here.  The birds can be heard trilling and singing when I open my eyes in the morning and the peepers greet me every morning singing sweetly when I leave the house. Every evening when I return the peepers’ chorus is very loud letting me know that yes, Spring has arrived (for me anyway).

I have been very busy writing articles and knitting, which is what I do to relax.  It has certainly taught me patience, which is a very good thing and why I stick with it.  I have a baby shower coming up in a few weeks and so I patiently sat many evenings knitting a sweater, hat and booties which will be my gift along with a book.

I have also been busy with my grandchildren, taking them shopping and outfitting them for Easter.  We had a trip to a nature center as well to learn about Maple and Walnut trees are tapped for sap and how the sap is boiled to make that tasty syrup we put on our pancakes and waffles.

Yes, I am excited for Spring and the rebirth of everything and I hope that you are as well.  Remember to look after each other and be kind to one another – let the folks you care about – know it – we are not promised tomorrow!

Until next time, take care…

Carol-signature

Categories
Excel 2013

How to Create A Workbook Clone in Excel

There may come a  time when you would like to make a copy of your workbook, without affecting the original. Excel does provide an easy method to do this.

Follow the steps below to learn how:

  1. Display the Open dialog box. (If you are using Excel 2007, click Office button | Open. If you are using Excel 2010 , click File | Open. If you are using Excel 2013, click File | Open | Computer |Browse.
  2. Select the workbook you would like to make a copy of.
  3. Click on the down-arrow on the right-hand side of the Open button. Excel will displas a list of different ways you can open the selected workbook.
  4. Select Open As Copy . Excel will  open a copy of the workbook.

The workbook that has been opened will use the same file name, but Excel will attach something at the beginning of the file name, as a prefix. For instance, you might see the file name prefixed with Customers copy or Copy (1). Thus, if the original workbook you selected in above is named Customers.xlsx, Excel will create a workbook named Copy of Budget.xlsx” or “Copy (1)Budget.xlsx.” If you want to rename the file, you will need to either use the Save As command, or rename the workbook after closing it.

Categories
Subscribers Outlook 2013

Subscribers: Want to Know What Link Contacts Does in Outlook?

Ever wonder what Link Contacts does in Outlook? Well if you have, as have some of my readers, here is the answer you have been searching for: As you may or may not know, Outlook can connect to multiple sources that provide a contact listing (i.e., Facebook, LinkedIn, Windows Live Messenger (via the Social Connector)). […]

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
Word 2013

How to Get rid of Manual Paragraph Numbering

How many times have you inherited a document that contains manual paragraph numbering and now you need to add paragraphs to it.  It takes time to renumber everything and frankly just opens up the margin for errors even wider, especially with very large documents. Luckily there is an easier method to accomplish this task.

Follow the steps below to learn how:

You can use regular editing techniques if your paragraphs are very short, meaning not over a single line each. All you need to do is to hold down the Alt key as you use the mouse to select the leading numbers and anything after them (like periods, spaces, or tabs). Press the Delete key, and just those leading characters are deleted.

For the Find and Replace method, follow these steps:

  1. Press Ctrl+H to display the Replace tab of the Find and Replace dialog box.

Replace

  1. Click the More button, if it is visible.
  2. Make sure the Use Wildcards  is selected.
  3. In the Find What area, key in (^13)[0-9]{1,}.[^09^32] .
  4. In the Replace With area, enter  \1 .
  5. Click on Replace All.
  6. Close the Find and Replace dialog box.

There are a few things to to be aware of about this technique:

First, it replaces any leading paragraph numbering that start with an Arabic number (1, 2, 3, etc.) followed by a period and either a tab or space. If your manually numbered paragraphs do not follow this pattern, then you will need to modify your search in step 4 above. For instance, if the numbering uses Roman numerals or letters then you’ll need to change what you search for.

Second, the technique assumes that there are no leading spaces or tabs before the number at the beginning of the paragraph. If there might be, then you’ll need to do a separate Find and Replace operation before this one in order to remove all leading spaces or tabs.

Categories
Subscribers Word 2016

Subscribers: How to Add a Full Page Border to your Document in Word

Yes, you can add borders to paragraphs in your Word documents.  But, you can also add a border to your entire page is you like. Why would you do this? Oh, I don't know, perhaps you want a fancy look for the first page or your report or you are creating a hand out for […]

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

Subscribers: How to Remove Print Preview Lines in Excel

Hate those little dotted lines that appear on your worksheets sometimes? This article will tell you how to remove or hide the Print Preview lines that will appear in Excel after you have adjusted a setting for printing and then gone back to the normal view of your worksheet. Follow the steps below to learn […]

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 2016

Subscribers: How to Hide Formatting Changes in Track Changes in Word

A client recently wrote to me about Track Changes in Word. She state that she uses Track Changes quite often and really loves using it and finds it very helpful. Her only problem with Track Changes it seems is that she does not like her formatting changes being listed in the changes. She wanted 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
Outlook 2013

Where is the Notes Folder in Outlook 2013??

Because of it’s limited use, the Notes folder is a bit more obscure. You can still access it by clicking on the Indicator next to Tasks.  Simply click on the three dots next to the Contacts symbol and you will see some choices.

Notes Folder Indicator

To make it permanently visible, follow the steps below:

Click on Navigation Options.

Navigation Options

Click on Notes and either move it up or increase the Maximum number of visible items from 4 to 5.

Move Up

If you followed the steps above, the bottom of your Outlook screen should now look something like this:

Noters Added

Categories
Subscribers Word 2013

Subscribers: How to Change Page Number Types in Headers & Footers in Word

As most of you may know, in Word, you can make your page numbers a part of your headers or footers. Once you have added the page numbers in your document, you might want to change the type of page numbers you have used. The good news is that Word will allow you to use […]

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 2016

Subscribers: How to Add Manual Line Breaks Within Justified Paragraphs in Word

A lot of folks use justified paragraphs in their documents.  Me, I'm not such a fan of that.  I like the look of the ragged edge, but many people such as lawyers, teachers, etc. like the look of that neat justified edge. As you know, in those paragraphs both the left and right edges of […]

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!