[mso] Re: Excel Headers

Sure Parker...if you group the sheets first, then everything you do will
be applied to all of the sheets

So, group the sheets by clicking on the sheet tab for the first sheet,
then hold your shift key down and click on the last sheet tab....you
will see that all of the sheet tabs are selected.....then make the
header

Then, right click on any one of the grouped sheets and choose Ungroup
sheets once you are done, cuz when the sheets are grouped, EVERYTHING
you do is applied to all sheets.

Grouping sheets is done just like selecting multiple files in
Windows.....use shift with the mouse to select all in between and use
control with the mouse to just group certain sheets.

Hope this helps.

Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
 


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Renaud, Parker
Sent: Tuesday, November 26, 2002 2:27 PM
To: Microsoft Office Group (E-mail)
Subject: [mso] Excel Headers



One of our users, who uses Excel extensively, wants to know if there is
a
way to create a header once and have it apply to all of the sheets in a
workbook.

Parker Renaud


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: