Microsoft Office Productivity

If you have a cell or cells containing e-mail addresses, they are probably hyperlinks. This type of Hyperlink will create an e-mail message with addresses already in the “To” field when you click on the cell. If you need to work with these cells it can be problematic to accidentally create an e-mail message by clicking on the cell. You can turn off the “Hyperlink” function in the cell or cells. Most of the time a Hyperlink is automatically created when you type a complete e-mail address in a cell in Excel.

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