Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default header/footer

As long as there's nothing else in that cell, you could try this:

Rightclick on any worksheet tab
choose Select all sheets
Select A3 (or whatever cell contains that date)
type the date and hit enter
rightclick on any of the tabs and select Ungroup Sheets.

Talladega wrote:

I have around 30 worksheets. The header on each of the worksheet has its own
separate title. I only want to change the third row to the current month.
Is there a way to do this by group selecting to only change the date and
leaving the other two rows the same? Here's an example.

Indy 500 Indy 500
Racing Racing
04/30/07 05/31/07

Ironman Ironman
Decathlon Decathlon
04/30/07 05/31/07


--

Dave Peterson
 
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
Header/Footer jackiemac1595 Excel Discussion (Misc queries) 5 July 29th 08 05:24 PM
Header and Footer Need Help Excel Worksheet Functions 1 July 7th 06 02:01 AM
Header/Footer Melanie New Users to Excel 2 August 30th 05 02:00 AM
Header and Footer Jav Excel Discussion (Misc queries) 2 August 11th 05 02:33 PM
header footer M&A_Jack Excel Worksheet Functions 1 March 8th 05 07:42 PM


All times are GMT +1. The time now is 06:56 AM.

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

About Us

"It's about Microsoft Excel"