To create a formula that calculates the amount of time elapsed between two different times of the day, subtract the starting time from the ending time. This tech-recipe describes how to accomplish this.
You can change the number of Undo levels in Excel. Keep reading to find out how.
To copy formatting from one cell or a range of cells to another cell or range of cells, use the Format Painter feature.
The Format Painter in Excel does more than just allow you to copy cell formatting. You can also use the Format Painter to copy column widths in a worksheet. To do this, use the steps below.
This registry hack will cause Outlook to go to the system tray when minimized. The registry changes to all the recent versions of Outlook (including XP, 2000, and 2003) are described in this tech-recipe.
Outlook allows you to display a second time zone in the Day and Work Week views. This can be useful if you frequently collaborate with someone in a different time zone. Use the following tech-recipe to accomplish this.
If your Personal Folders data file (.pst) becomes corrupted, you can often repair it by using the Inbox Repair Tool. Keep reading to find out how.
By default, Outlook Calendar compresses the Saturday and Sunday fields in the Week and Month views. To get more space on the weekends, use the following tech-recipe.
Excel recalculates the entire table if you make changes to any of the variables in a table formula. This can be problematic with large tables, which can take a long time to calculate. If you prefer to control the table recalculation, use the steps below.
To prevent other users from seeing or modifying your formulas, format the relevant cells as hidden, and then protect the worksheet or worksheets. Use the following tech-recipe to accomplish this.
The association between a color and a label can be changed to be different from Outlook’s defaults. You can do so by editing the labels’ text.
Excel can automatically size a column or columns which you have selected, based on their longest entries. This gives you a quick and easy way to display your data in a worksheet.
1...259260261...528Page 260 of 528
error: Content is protected !!
