Categories
Carol's Ramblings

Family, Friends, Co-Workers, and Gratitude…

We just celebrated Easter about a week ago.  It was so nice, my son and his wife and daughters went to church with us and then they and my daughter, her husband and their sons came back to the house and we all had a bite to eat.  The little ones were so anxious to start the Easter egg hunt!  And what fun they had with that hunt!  A joy to watch them running back and forth and the shouts “I got one” emanating from them.  I hope you all enjoyed a similar holiday, be it Easter or Passover or your particular celebration.

Spring has finally sprung and the earth is warming, trees are sprouting leaves and flowers are showing buds and blooms.  It’s like a whole new beginning.  The new year starts in January but for me, it starts with the renewal of Spring.  Everything comes back to life.  It makes me introspective.

We all thoughtlessly complain about petty, silly, little annoyances in our lives. We don’t even give it a second thought.  Until something really scary and important crops up and then we think about our petty little annoyances and how we griped about them.  I had one of those moments last week.  My son-in-law, whom I love dearly, found that he is having a health problem and it could be a very major problem.  We heard the scary “C” word.  And then I plopped myself down and thought “Wow Carol, you have been so lucky, so blessed, led a charmed life really, compared to many people.  I vowed not to complain about those petty things again. I also vowed to show the people I love, the people I care deeply about, my friends, co-workers – everyone, how I feel about them.  Oh, I know I will slip and complain about silly things again, but this was an eye-opener.   Perhaps that is why these things occur in our lives, to make us appreciate all the good in our lives that we do not see all the time.  So I thought I would share this with you because after all, you are all humans, just like me.  Something to thing about…

The Hyacinths are blooming in my yard, pink ones, white ones and purple ones.  There are a few Daffodils about to bloom outside my office window as well.  And the peepers….my lovely little peepers.  The symphony they perform these Spring evenings.  It is a delight of nature.  I love listening to it.  I am so very thankful for this new beginning, this Springtime.  Sometimes I try to take a mental picture so I can hold onto it just in case I never get to see it again.

Wherever you are, I hope that you are all experiencing this rebirth of the earth with all the attendant blooms and budding, sights and sounds to delight the eye, ear and mind.  I wish you all the peace of a spring morning.  Please take the time to really look around you and appreciate the art we take for granted every day.

I hope you enjoy the newsletter this month.  Please send some positive energy and/or prayers out to all the other people in the world who are having health issues and I will do the same for you.

Until next time, take care of you…

Carol-signature

Categories
Subscribers Excel 2010

Subscribers: How to Correct a Capital Mistake in Excel

How many times have your fingers been flying over your keyboard and then you happen to glance down and discover that Caps Lock is on?  Isn't that so aggravating?? Fortunately, Excel can catch my error for me - IF I tell it to! Follow the steps below to learn how: On your Ribbon, Click 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 2010

How to Quickly and Easily Zoom in Excel

If you spend a lot of time zooming in your Excel worksheets I am sure you will agree that it becomes very tiresome very quickly! It also uses a lot of time which we all know I hate to do!

So, if you have a mouse with a small wheel between the left and right mouse buttons, there is a cool little trick that you can use to do your zooming.

All you really need to do is hold down your CTRL  key while simultaneously turning that small wheel!  Each click up or down will increase or decrease the zoom factor by 15%.

Also, you can use this method o zoom any magnification between ten and one hundred percent! If, for whatever reason you would want to, if you want to zoom over 100%, you would have to use the controls on the View tab of your Ribbon.

But, if you like this feature a lot and would like to use it to zoom all the time in your Excel worksheets, you can tell Excel to always use your mouse wheel to zoom.

Follow the steps below to learn how:

  1. Display the Excel Options dialog box (in Excel 2007, click the Office button and then click Excel Options). In Excel 2010, Click the File tab on your Ribbon and click Options.
  2. Click the Advanced option at the left-hand side of the dialog box.
  3. In the Editing area, select the Zoom On Roll with IntelliMouse check box.

Options

  1. Click OK.

You can now zoom using your mouse wheel or scroll through your worksheet by holding down the CTRL key while using the wheel.

 

Categories
Word 2010

How to Get Rid of that Graph Paper Effect in Word!

I have received frantic e-mails and phone calls from clients telling me that all of a sudden when they open Word their document opens up with a strange graph paper effect.

Grid Lines

Well, there are a couple of reasons why this may have happened, but the most likely reason is that the drawing grid has been turned on.

Follow the steps below to learn how to turn it off:

  1. Click the View tab of your Ribbon.
  2. In the Show/Hide group, deselect the Gridlines check box.

Show Hide

Should you find that the drawing grid was not turned on, then the problem could possibly be related to a background image being set on your system.

Follow the steps below to learn how to get rid of any background image:

  1. Click the Page Layout tab on your Ribbon.
  2. In the Page Background group, click Page Color. Word will display a drop-down menu of choices.
  3. Click No Color.

That’s all there is to it.  Easy peasy!

Categories
Subscribers Word 2010

Subscribers: How to Quickly Change Tab Alignment in your Documents

As most of you know, Word will allow you to insert many different tab types in your documents. If you use styles (and I hope you do!) changing the alignment of tab stops in certain types of paragraphs is very easy. However, if you use non-style formatting, it can be a bit more difficult. Supposing […]

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 2010

How to Display a Hidden First Row in Excel

Excel is such a great program and it makes it so easy to hide and unhide rows in our worksheets, using the menus.

What isn‘t very easy is displaying a hidden row if that row happens to be the first visible row in your worksheet. (i.e., if you hide rows 1 through 5 of your worksheet, Excel will obey your instructions). If you decide later that you would like to unhide any of these rows, however, it is not very intuitive as to how you should go about that!

Follow the steps below to learn how to unhide the top rows of your worksheet when they are hidden:

  1. Click F5 to display the Go To dialog box.

Go To

  1. In the Reference field at the bottom of the dialog box, enter the number of the row range that you would like to unhide. (i.e., if you would like to unhide rows 3 through 4, key in 3:4). By the same token, if you would like to unhide row 1, you would key in 1:1.
  2. Click on OK. The rows you specified are now selected. You will not see it on your screen but they are.
  3. From the Format menu, select Row and then Unhide.

 

 

Categories
Subscribers Excel 2010

Subscribers: How to Shade Cells Based on Odd and Even In Excel

When your worksheet has a range of cells with a series of values, you may choose to use a different format to show the difference between the odd and even values. The method to do this is using the Conditional Formatting feature. Follow the steps below to learn how: Select the cells that contain odd […]

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 Add an Ellipsis at the Beginning of Paragraphs

Suppose you have a document that you are working on that has multiple paragraphs that begin with incomplete sentences. This happens often in legal, academic and technical documents. It normally is very apparent where these incomplete sentences are placed because the paragraph starts with a word with a lowercase letter rather than uppercase. So how […]

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 Deal with Long Lines in Your Address Labels

Word will create address labels for you from data that has been stored in a different source (i.e., Access database or Excel workbook). Essentially, Word takes the information from those sources and places it into the format that you designate in Word.  Because it has been put into Word format, it it now possible that […]

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

Subscribers: How to Make Comments Visible Only when Hovering Over a Word or Phrase

As you may or many not know, in Excel you can add a comment to a cell that is only visible when someone hovers their mouse over it. But can you do it in Word as well? The short answer is no, it does not happen by default.  But, there is a "kinda" "sorta" was […]

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!