| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group page selection and deselection
I have a worksheet with several tabs, each containing a table of data
related to that tab (eg. Tab name is employee name) page contains weekly hours, job pay data. I can change the week beginning and some other common data on all the pages by selecting all of the tabs by shift-Click. However, I couldn't deselect a page to get out of group mode. So, I added another page that I don't include in the group. How can I get out of group mode without using this extra ungrouped page? Is it possible to group non-contiguous pages? For example tab1, tab4, tab5, and tab7 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Group page selection and deselection
Right click on any selected Sheet tab and select UNGROUP SHEETS.
Hope this helps... -- Kevin Backmann "Gene Augustin" wrote: I have a worksheet with several tabs, each containing a table of data related to that tab (eg. Tab name is employee name) page contains weekly hours, job pay data. I can change the week beginning and some other common data on all the pages by selecting all of the tabs by shift-Click. However, I couldn't deselect a page to get out of group mode. So, I added another page that I don't include in the group. How can I get out of group mode without using this extra ungrouped page? Is it possible to group non-contiguous pages? For example tab1, tab4, tab5, and tab7 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Group page selection and deselection
To select non-contiguous worksheets just hold down the CTRL key and click on
the tab to select. -- Kevin Backmann "Kevin B" wrote: Right click on any selected Sheet tab and select UNGROUP SHEETS. Hope this helps... -- Kevin Backmann "Gene Augustin" wrote: I have a worksheet with several tabs, each containing a table of data related to that tab (eg. Tab name is employee name) page contains weekly hours, job pay data. I can change the week beginning and some other common data on all the pages by selecting all of the tabs by shift-Click. However, I couldn't deselect a page to get out of group mode. So, I added another page that I don't include in the group. How can I get out of group mode without using this extra ungrouped page? Is it possible to group non-contiguous pages? For example tab1, tab4, tab5, and tab7 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Group that Selection error in PivotTable | Excel Discussion (Misc queries) | |||
| excel 2000 shortcut for deselection | Excel Discussion (Misc queries) | |||
| cannot group that selection | Charts and Charting in Excel | |||
| Calculation of Selection Group using Arrays (or VBA?) | Excel Worksheet Functions | |||
| Cannot Group that selection Problem | Excel Discussion (Misc queries) | |||
Linear Mode
