View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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