View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Khoshravan Khoshravan is offline
external usenet poster
 
Posts: 211
Default How do I set up 12 months/31 days each dated spreadsheets?

As for first part, click on tab name and keep it a second, a small page icon
will appear, then you can drag it and drop where ever you want. This way you
can change the location of tabs.
As for second part, please give us more detail about what are you going to
do in each day (separate tab). without knowing your plan, it might not be
wise way to produce one sheet per day. Later you might have problems
consolidating data from so many sheets into one sheet for analysis and
summarizing.
But if you insist you have to look for a Macro to do this for you.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"kayak99" wrote:

I tried that earlier and it added the tabs backwards, i.e. 6, 5, 4, 1, 2, 3.

Will that matter when I name them Jan 1, Jan 2, Jan 3, etc and what's the
best way to name those without doing it individually?

Thanks



"Khoshravan" wrote:

Insert| Worksheet. This will add worksheets and you will see tabs in the
bottom. To speed up process for adding WS, you can press Ctrl+Y, after
inserting 1st WS. Then double click the tabs to change the names.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"kayak99" wrote:

How do I add tabs and set up 12 months of (31 days each) dated spreadsheets?
I can delete any tabs of shorter months.


Thanks