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.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ray Naylor" wrote in message
...
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?
"Gord Dibben" wrote:
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
On Thu, 28 Sep 2006 12:31:02 -0700, Ray Naylor
wrote:
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.
"Gord Dibben" wrote:
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
On Thu, 28 Sep 2006 11:17:01 -0700, Ray Naylor <Ray
wrote:
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.