How to create or edit worksheet titles or text

You create or edit worksheet titles and text when you want to add text to the top or bottom of a worksheet. For example, you might want to display the current date at the top of a weekly report.

To create or edit a worksheet title or worksheet text:

1. Open the workbook containing the worksheet that you want to edit (for more information, see "How to open workbooks").

2. Display the worksheet that you want to edit.

3. If you want to edit or create worksheet title text, choose Edit | Title to display the "Edit Title dialog" and use this dialog to specify a worksheet title, as follows:

   • Use the Font, Size, Color, and Background color buttons to format the worksheet title area.

   • Use the Title field to enter text that you want to display in the title area of the worksheet.

   • Use the Insert drop down list to add text variables (e.g. date and time that are updated at runtime).

   
   Description of the illustration edit_t.gif
   
   

   Hint: You can also double-click on the worksheet title area (if displayed) to display the "Edit Title dialog". For more information, see "How to display or hide worksheet titles or text".

4. If you want to edit or create worksheet text, choose Edit | Text Area to display the "Edit Text Area dialog" and use this dialog to specify worksheet text, as follows:

   • Use the Font, Size, Color, and Background color buttons to format text in the worksheet text area.

   • Use the Text field to enter text that you want to display in the text area on the worksheet.

   • Use the Insert drop down list to add text variables (e.g. date and time that are updated at runtime).

   
   Description of the illustration edit_wt.gif
   
   

   Hint: You can also double-click on the worksheet text area (if displayed) to display the "Edit Text Area dialog". For more information, see "How to display or hide worksheet titles or text".

5. Click OK to save changes that you make.

   The worksheet is updated with changes that you specified.