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)
-
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?... -
I've had a few people ask me lately how to filter lists using Excel. It really is as simple as clicking a button on the Ribbon. If you...
-
When Outlook is first setup, the default Auto-Archive is 6 months. This means that e-mails dated 6 months ago will automatically be moved...
No comments:
Post a Comment