Group page selection and deselection

G

Gene Augustin

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
 
K

Kevin B

Right click on any selected Sheet tab and select UNGROUP SHEETS.

Hope this helps...
 
K

Kevin B

To select non-contiguous worksheets just hold down the CTRL key and click on
the tab to select.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting excel to PDF, single page converts to multiple HELP! 1
Controls erroneously show on Multiple Tabs 2
macro showing and hiding detail 1
how do I get my Data tab to work? It is completely greyed out. 1
How to auto keep group of rows together and avoid a page break 2
Insert row in Master worksheet that auto inserts in other workshee 3
Excel formula for report 4
Need a title and page number on page 1 page numbers only for the rest of the document 1

Top