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.
Most Popular
-
Intrenational users sometimes view things differently than here in the US. But, did you know you can change Excel to International View? ... -
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?... -
Have you ever printed a document only to remember that you forgot to print that one last line? Save a tree and save some ink with this tip. ...
No comments:
Post a Comment