Renaming and Coloring Worksheet Tabs

graphics/07inf07.jpg

graphics/one_icon.jpg

Right-click the tab of the worksheet you want to rename (for example, Sheet1), and select Rename from the shortcut menu.

graphics/tow_icon.jpg

Type a new name for the worksheet and press the Enter key. Repeat this for each tab you want to rename.

graphics/three_icon.jpg

Right-click the tab of the worksheet you want to colorize and select Tab Color from the shortcut menu.

graphics/foure_icon.jpg

The Format Tab Color dialog box opens; click the desired color and click OK. The worksheet tab displays the selected color.

INTRODUCTION

The more you work in Excel, the more you will need to organize and keep track of your worksheets and the data they contain. A quick way to maintain the worksheets within a workbook is to assign them individual names, such as Region1Sales, Region2Sales, and so on. In addition, if you want to indicate something specific about a worksheet (for example, if a worksheet contains information about a particular sales region that is not doing well), you can assign it a tab color.

TIP

Double-Clicking a Tab to Rename It

If you prefer, you can double-click a worksheet tab to rename it. Simply type in the new name and continue working.



Easy Microsoft Office 2003
Easy Microsoft Office 2003
ISBN: 0789729628
EAN: 2147483647
Year: 2003
Pages: 281
Authors: Nancy Lewis

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net