![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com