 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2006Can columns be hidden accross multiple sheets in an Excel workboo
Is it possible to group and hide colums in an Excel workbook across multiple sheets at once without having to group and ungroup colums for each page? I have a workbook with thirty sheets that I use to keep track of 25 peoples production during a month. If a person leaves, I would like to be able to hide that column once and have that column hidden on the other pages. I am using Excel 2003. Right-click on the first sheet tab and "select all sheets" Hide the column(s) on the active sheet and will be done to all sheets. DO NOT FORGET to ungroup after this task is complete. To select just some sheets use CTRL + click on tabs or for a contiguous range of sheets use SHIFT + click Gord Dibben MS Excel MVP >Is it possible to group and hide colums in an Excel workbook across multiple >sheets at once without having to group and ungroup colums for each page? I >have a workbook with thirty sheets that I use to keep track of 25 peoples >production during a month. If a person leaves, I would like to be able to >hide that column once and have that column hidden on the other pages. I am >using Excel 2003. Gord, When I right click sheet 1 and go to group a column, the options to group or ungroup are grayed out and I can't group a column. > Right-click on the first sheet tab and "select all sheets" > [quoted text clipped - 13 lines] > >hide that column once and have that column hidden on the other pages. I am > >using Excel 2003. Read my post again. Right-click on the first sheet tab and "Select all sheets". You are not grouping columns, but grouping sheets. Gord Dibben MS Excel MVP >Gord, When I right click sheet 1 and go to group a column, the options to >group or ungroup are grayed out and I can't group a column. [quoted text clipped - 16 lines] >> >hide that column once and have that column hidden on the other pages. I am >> >using Excel 2003. Gord, Maybe I haven't been clear with what I am looking to do. I have a workbook with 30 sheets and I would like to be able to hide the column "C" on each page without having to go to each page, select the column, and group that column. What you suggested allows me to select all the sheets (the tabs turn white), but when I go to group column "C", the options to group or ungroup a column is greyed out. Could it be a feature that needs to be installed off of the Office 2003 CD? > Read my post again. > [quoted text clipped - 24 lines] > >> >hide that column once and have that column hidden on the other pages. I am > >> >using Excel 2003. Hi Ray, you do not need to group, as Gord told you whem you selected all sheets (all tab names in blank) ANY action you did in ANY sheet will be "repeated" in all sheets of this workbook. so select all and hide the C column. Pay attention in Gord's post about "DO NOT FORGET to ungroup after this task is complete" hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > Gord, > Maybe I haven't been clear with what I am looking to do. I have a workbook [quoted text clipped - 33 lines] > > >> >hide that column once and have that column hidden on the other pages. I am > > >> >using Excel 2003. Ray You have been perfectly clear about what you want to do. You say you are wanting to "Hide" column C on each worksheet. Why are you trying to "group" column C? After you have all sheets selected, just select column C on the active sheet and Format>Column>Hide. Gord >Gord, >Maybe I haven't been clear with what I am looking to do. I have a workbook [quoted text clipped - 33 lines] >> >> >hide that column once and have that column hidden on the other pages. I am >> >> >using Excel 2003. Gord Dibben MS Excel MVP You're confusing everyone by your use of incorrect terminology. You're *not* looking to *hide* Column C. You're looking to *collapse* Column C. And you're looking to do this by using the *outline* symbols. You *cannot* create and/or set-up groups of rows and columns while *sheets are grouped*. You can create a single sheet with your groupings, and then copy that sheet to create other sheets with the same settings. If the 30 sheets are already in existence, then perhaps code can do this for you. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Gord, > Maybe I haven't been clear with what I am looking to do. I have a [quoted text clipped - 44 lines] >> >> >I am >> >> >using Excel 2003. RD Collapse, not hide. I think you've got it! The rain does fall mainly on the plain. Gord >You're confusing everyone by your use of incorrect terminology. > [quoted text clipped - 10 lines] >If the 30 sheets are already in existence, then perhaps code can do this for >you. Gord Dibben MS Excel MVP You guys are awesome!!! Going to Format, Column, Hide worked. Apparently trying to use Data, Group and Outline, Group was not the way to go. > RD > [quoted text clipped - 22 lines] > > Gord Dibben MS Excel MVP So it was "hide" and not "collapse". Thanks for the feedback. Gord >You guys are awesome!!! >Going to Format, Column, Hide worked. Apparently trying to use Data, Group [quoted text clipped - 26 lines] >> >> Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP Now that's an original approach! To even think about using group and outline to hide rows and columns.<g> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > So it was "hide" and not "collapse". > [quoted text clipped - 34 lines] > > Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.