Thread
:
Can columns be hidden accross multiple sheets in an Excel workboo
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
Can columns be hidden accross multiple sheets in an Excel workboo
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.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben