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
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.
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
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,
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
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: Right-click on the sheet tab
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
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: Position your insertion point where
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
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
