View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.