im on excel and i know its a simple solution i just cant figure it out........i have a main page that is the summary of a ton of workbook pages, and i want 1/1/08 on every workbook page without manually having to type it in on each workbook page. anyone know how to do this

1/1/2008 3:53:30 PM

select all worksheets ("pages") at once - select the first worksheet, then hold down Shift and click the last worksheet. They will all be selected, then when you type in any of them, all worksheets will be updated

1/1/2008 4:23:55 PM

thx me and my boss both thank you

1/1/2008 6:44:22 PM