Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
WillieR
 
Posts: n/a
Default One header for all worksheets in workbook

Is there an easy &/or quick way to make a common header for all worksheets in
a workbook?? We use workbooks w/monthly worksheets to track our employees
work & it would be nice to be able to change header information without
having to go to each individual worksheet.
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
just select all of your sheets (group them with holding down the cTRL
key while selecting them)

--
Regards
Frank Kabel
Frankfurt, Germany

"WillieR" schrieb im Newsbeitrag
...
Is there an easy &/or quick way to make a common header for all

worksheets in
a workbook?? We use workbooks w/monthly worksheets to track our

employees
work & it would be nice to be able to change header information

without
having to go to each individual worksheet.


  #3   Report Post  
WillieR
 
Posts: n/a
Default

Thanks, Frank! That will save me a lot of time!

"Frank Kabel" wrote:

Hi
just select all of your sheets (group them with holding down the cTRL
key while selecting them)

--
Regards
Frank Kabel
Frankfurt, Germany

"WillieR" schrieb im Newsbeitrag
...
Is there an easy &/or quick way to make a common header for all

worksheets in
a workbook?? We use workbooks w/monthly worksheets to track our

employees
work & it would be nice to be able to change header information

without
having to go to each individual worksheet.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
linking cell value in one workbook to a cell in another workbook Jig Bhakta Links and Linking in Excel 1 January 20th 05 07:12 PM
sotring worksheets in a workbook pineywoods Charts and Charting in Excel 3 December 22nd 04 11:11 PM
Linking to Worksheets on Excel -Saved Web Page Lawman Links and Linking in Excel 3 December 8th 04 09:13 AM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 07:15 PM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"