Can columns be hidden accross multiple sheets in an Excel workboo

[Guest]

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 Dibben]

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

 

[Guest]

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]

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

 

[Guest]

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?

 

[Guest]

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
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ray Naylor" escreveu:

 

[Gord Dibben]

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
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 MS Excel MVP

 

[RagDyer]

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.

 

[Gord Dibben]

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.

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.

Gord Dibben MS Excel MVP

 

[Guest]

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.

 

[Gord Dibben]

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
and Outline, Group was not the way to go.

Gord Dibben MS Excel MVP

 

[Ragdyer]

Now that's an original approach!

To even think about using group and outline to hide rows and columns.<g>

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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
and Outline, Group was not the way to go.

RD

Collapse, not hide.

I think you've got it!

The rain does fall mainly on the plain.


Gord