Microsoft Excel

How to Quickly Move Between Excel Workbooks

Use keyboard shortcuts to move between your workbooks in Excel:

  • The keyboard shortcut for moving to the next open workbook is either Ctrl + Tab or Ctrl + F6.
  • To move to the previous open workbook, click Ctrl + Shift + Tab.
  • Click Alt + W to open the Window menu and then the workbook index number.
Microsoft Excel

Quickly Change Formatting in an Excel Worksheet

To copy the formatting, use the Format Painter.

  • Click the Format Painter icon to copy and apply formatting.

To repeatedly copy formatting:

  • Double-click the Format Painter icon to repeatedly apply formatting.
Microsoft Excel

Change Excel Cell Formatting from a Date to a Number

When you want to change your cell formatting in MS Excel from Date to Number, follow the steps below:

  • Click Ctrl + Shift + ~>.

Go ahead and try it out.

  • Enter today’s date in a cell by clicking Ctrl + ;.
  • Then click Ctrl + Shift + ~> to change the format to General formatting.

Nice little shortcut isn’t it?

Microsoft Outlook

How to Add a Second Sort Column in Outlook

Most folks know that they can sort their Outlook items by clicking a column title. Clicking actually toggles between ascending and descending order in a sort.

What relatively few folks know, is that MS Outlook does not limit you to a single column sort. That’s right! You can have it your way!

To learn how, follow the steps below:

  1. Sort your primary column.
  2. When you are finished, depress the Shift key and click the column cell that represents your secondary sort group.

The secondary sort adds a descending sort by size, as indicated by the small down arrow. The difference is very subtle.

Only the messages in the first group re-sort, sorting according to size.

Windows XP

Organizing the Programs Menu in Windows XP

We get our nice new computers and then we start adding new programs and applications. After a while, you start to notice that each new program gets added to the bottom of your Programs menu. And before you know it, when you want to open a program or application finding it can be a little problematic. The good news is that you can organize your programs and applications.

Follow the steps below to learn how:

  1. Click Start | All Programs.
  2. Right-click on one item.
  3. A shortcut menu will appear.
  4. Select Sort by Name.

That makes things a bit more organized now, doesn’t it?

Microsoft Excel

How to Make Colored Sheet tabs in Excel

Starting with version 2002, the ability to add color to your worksheet tabs was introduced to MS Excel. This can be very useful in applying theme colors to related sheets in your workbook, besides just being fun and making your worksheets look good.

To learn how, follow the steps below:

  1. Right-click on the sheet tab where you would like to apply a color.
  2. Select Tab Color.
  3. Select the color of your choosing.
  4. Click OK.

Follow the steps above to apply color to subsequent tabs.

Microsoft Excel

Align Objects with Cell Borders in Excel

If you use text boxes frequently and other AutoShapes in your workbooks, you might want to align those objects with the edge of your cells. Before I learned this handy little trick it drove me to distraction when trying to align!

Select the object you would like to align and depress and hold down the ALT key while moving it.

You can also resize objects to fit a cell or range of cells by dragging the sizing handles using the same trick!

Microsoft Word

How to Use a slashed Zero in Word

There are some occasions when one may want to add the occasional slashed zero in a document. There are a couple of methods to accomplish this in MS Word, such as passwords to differentiate between a number zero and a capital letter O.

Follow the steps below to learn how:

  1. Position your insertion point where you would like to insert your slashed zero.
  2. Click Ctrl + F9. MS Word will insert field braces.
  3. Between the braces, key in eq \ o (0,/).
  4. Click Shift + F9 and MS Word will display your slashed zero.

That’s all there is to it!

Word 2007

Quick Access to the Horizontal Ruler in Word 2007

MS Word displays the horizontal ruler depending upon which view you use. It will be displayed in the Normal, Print, and Web view.

Some folks do not like to have the horizontal ruler visible as it takes up valuable real estate space on their Word screen. It is, however, possible to have the best of both worlds. You can have your horizontal ruler available to you and still have extra real estate space available on your screen.

Even if you turn off the Ruler it is still there represented by a thin gray line. All you need is the proper settings!

  1. Click the Office button and Word Options. Then select Advanced on the left-hand side.
  2. In the General Options area, check the Provide Feedback With Animation option.
  3. Click OK.

With the Ruler unchecked on the View menu and the above setting, you can position your cursor over the gray line below the toolbar and the animation setting will kick in and the Ruler will roll down. When you move the cursor away from the Ruler it rolls back up under the Toolbar.

Windows XP

Uncover the Hybernate Function in Windows XP

Many folks have complained to me that they do not have the hibernate option on the Shut Down dialog box in Windows XP. They think that the option is not available in Windows XP, but it is. You just need to know where to find it!

All you have to do is simply hold the the SHIFT key while the Shut Down dialog box is visible and the Stand By option changes to Hibernate.

Another mystery solved!