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.
Subscribe to:
Post Comments (Atom)
-
Many people are familiar with online e-mail accounts that provide access from anywhere you have Internet access. These accounts include G...
-
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...
-
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
No comments:
Post a Comment