Use keyboard shortcuts to move between your workbooks in Excel:
To copy the formatting, use the Format Painter.
To repeatedly copy formatting:
When you want to change your cell formatting in MS Excel from Date to Number, follow the steps below:
Go ahead and try it out.
Nice little shortcut isn’t it?
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:
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.
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:
That makes things a bit more organized now, doesn’t it?
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:
Follow the steps above to apply color to subsequent tabs.
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!
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:
That’s all there is to it!
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!
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.
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!
