Is there a time saver?

pjindc · Apr 22nd, 2002, 11:28 AM

I have a Workbook with multiple spreadsheets. Recently my company changed it's name and therefor I must change my email in the header.
All my worksheets are the same with the top three lines stating the date, title of worksheet, and my email.
Is there a quick way to change the data of the header and for it to copy to all my other header's?

Mark W. · Apr 22nd, 2002, 11:30 AM

Right-click any worksheet tab, choose "Select All Sheets" from the popup menu, choose the File | Page Setup... and make your header change.

rcavedo · Apr 22nd, 2002, 02:56 PM

I have the same problem. But I am trying to do it to most of my workBOOKS. Is there a way to do it without typing the new header for EACH workBOOK?

Bob

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 11:28 AM	#1
pjindc New Member Join Date: Apr 2002 Posts: 4	I have a Workbook with multiple spreadsheets. Recently my company changed it's name and therefor I must change my email in the header. All my worksheets are the same with the top three lines stating the date, title of worksheet, and my email. Is there a quick way to change the data of the header and for it to copy to all my other header's?

Apr 22nd, 2002, 11:30 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Right-click any worksheet tab, choose "Select All Sheets" from the popup menu, choose the File \| Page Setup... and make your header change.

Apr 22nd, 2002, 02:56 PM	#3
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	I have the same problem. But I am trying to do it to most of my workBOOKS. Is there a way to do it without typing the new header for EACH workBOOK? Bob