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

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.

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.

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.

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.

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,
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.

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
FormatColumnHide.


Gord

On Thu, 28 Sep 2006 13:20:01 -0700, Ray Naylor
wrote:

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.





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.
--
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.

RD

Collapse, not hide.

I think you've got it!

The rain does fall mainly on the plain.


Gord

On Thu, 28 Sep 2006 19:06:13 -0700, "RagDyer" wrote:

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

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" wrote:

RD

Collapse, not hide.

I think you've got it!

The rain does fall mainly on the plain.


Gord

On Thu, 28 Sep 2006 19:06:13 -0700, "RagDyer" wrote:

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

So it was "hide" and not "collapse".

Thanks for the feedback.

Gord

On Fri, 29 Sep 2006 05:16:02 -0700, Ray Naylor
wrote:

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" wrote:

RD

Collapse, not hide.

I think you've got it!

The rain does fall mainly on the plain.


Gord

On Thu, 28 Sep 2006 19:06:13 -0700, "RagDyer" wrote:

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


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

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
So it was "hide" and not "collapse".

Thanks for the feedback.

Gord

On Fri, 29 Sep 2006 05:16:02 -0700, Ray Naylor
wrote:

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" wrote:

RD

Collapse, not hide.

I think you've got it!

The rain does fall mainly on the plain.


Gord

On Thu, 28 Sep 2006 19:06:13 -0700, "RagDyer"
wrote:

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


Gord Dibben MS Excel MVP