Rename and color worksheet tabs


show more Rename and color worksheet tabs provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Rename and color worksheet tabs

Here we have a workbook that has more than one worksheet in it. We've copied our information from Sheet1 to Sheet2. Well, assuming that those two sheets had unique information it would be appropriate for us to identify those sheets by renaming the tabs. The default Sheet1, Sheet2, Sheet3, etc. is not very descriptive. If we go to Sheet1, we can right-click on that tab, from this quick menu we choose Rename and you'll see that the sheet title has been highlighted and is waiting for us to enter some information. So let's enter Annual Sales. I'll remind you again of the added complexity in using a sheet's external reference when you add a space to the name, but I don't think it should deter you. Let's remove the formatting here and Sheet2, select that tab, go up to Format > Sheet, and you'll see here, Rename is also an option, does exactly the same thing, just the long way around. We'll call this one Copy. You can also add color to those tabs, if it...

Rename and color worksheet tabs
Video duration: 1m 51s 4h 8m Beginner

Viewers:

Rename and color worksheet tabs provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...