Folder/Tabs Newbie Question
in [General]
|
Prev: how to use countif to incorporate filters
Next: can I have a multiselect option for a list box in excel 2003
From: Andrew on 15 Mar 2010 13:10 When you create a spreadsheet Excel creates 3 tabs at the bottom - is it possible to open one of the tabs and create a set of sub-tabs, ie I could have a main tab for week one, week two etc. and the within the tab Week1 could I have 7 sub tabs for each day of the week. Many Regards Andrew
From: Gord Dibben on 15 Mar 2010 13:29 No. You can add more sheets to a workbook. Alternative..... In Excel 2003 you can have 7 distinct Data>Lists on a sheet. In Excel 2007 you can have 7 distinct Insert>Tables on a sheet. Gord Dibben MS Excel MVP On Mon, 15 Mar 2010 10:10:02 -0700, Andrew <Andrew(a)discussions.microsoft.com> wrote: >When you create a spreadsheet Excel creates 3 tabs at the bottom - is it >possible to open one of the tabs and create a set of sub-tabs, ie I could >have a main tab for week one, week two etc. and the within the tab Week1 >could I have 7 sub tabs for each day of the week. > >Many Regards > >Andrew
From: Paul C on 15 Mar 2010 14:08
Each tab is a sheet. You cannot have sub-sheets. -- If this helps, please remember to click yes. "Andrew" wrote: > When you create a spreadsheet Excel creates 3 tabs at the bottom - is it > possible to open one of the tabs and create a set of sub-tabs, ie I could > have a main tab for week one, week two etc. and the within the tab Week1 > could I have 7 sub tabs for each day of the week. > > Many Regards > > Andrew |