Alternative way to show 12 tabs??
Hi Robert
You have had answers about tab size.
However, I would urge you not to put your data in 12 separate tabs,
unless the amount of overall data for the year is going to exceed 65,536
rows (XL2003) or 1 million rows (XL2007).
For subsequent analysis, you will find it much easier to have all the
data on one tab.
Add an extra column to your existing data, headed Month.
Use Autofilter to filter my month to show any individual Month's data.
--
Regards
Roger Govier
Robert Crandal wrote:
I'm thinking about creating a yearly Excel file where
each month will have its own sheet and associated
tab. This means that my file will contain 12 tabs.
The problem with having 12 tabs is that they all cannot
be visible at the same time at the bottom of the
workbook, due to the limited width at the bottom.
Ideally, I would like all 12 tabs to be visible at the
same time. Is this possible? If not, does anyone
have any creative ideas on how to create a 12
sheet workbook that doesnt involve cluttered
or partially visible tabs at the bottom of the workbook??
thank u!
|