Friday, September 11, 2009

Naming Excel Worksheet Tabs

If you have large Excel spreadsheets with multiple Tabs, it may help you to Name each Tab with a name that is relative to the data contained within the Tab.

As a default, Excel opens three (3) worksheets. Each worksheet has a Tab at the bottom of the screen named "Sheet1", "Sheet2", and "Sheet3". Obviously these mean nothing if you have data on Sheet2 that is February's data.

To rename the Tabs, simply follow these steps:

1) Double-click the Tab and Replace the name "Sheet1" with whatever you would like it to be. For example, "JAN" for January's data.

2) Once you have typed the new name, simply click ENTER.

Now the Tab makes more sense and will help you move amongst the Tabs quicker.

No comments:

Post a Comment

How to Delete Blank Rows in Excel