ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Group page selection and deselection (https://www.excelbanter.com/excel-discussion-misc-queries/219231-group-page-selection-deselection.html)

Gene Augustin

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


Kevin B

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



Kevin B

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