Can columns be hidden accross multiple sheets in an Excel work
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
|