Using “Auto Correct” for frequently used text, will help you save time when composing e-mail messages. You can create “shortcuts” that allow you to type in a few letters and Outlook will convert them into phrases as you type.
If you are using all the worksheets in a workbook, and want to add the same header and/or footer to all the sheets, it can be done so they are all added at the same time.
Sometimes it may be necessary to change the case of certain text in an Excel Worksheet. This can be changed to all lower case, all upper case and proper case with the first letter capitalized. In this example we will take data entered into a worksheet by multiple individuals that is in different cases and covert the text into the same case. This works in Excel 2010, Excel 2007, Excel 2003. The formula will work the same for all cases, you will just need to use one of the following: =LOWER =UPPER =PROPER
You can quickly hide worksheets so they are no longer in view. Two different ways to hide worksheets will be shown in this tutorial. This process works the same in Excel 2007 and Excel 2010.
If you have created a char in the same worksheet as your chart data, or in a separate worksheet, you can easily delete it if you no longer need it. This will work the same in Excel 2003, Excel 2007 and Excel 2010.