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!