MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Current Time Stamp

Posted by Dave B on August 24, 2001 12:37 PM

Can you tell me a way to have the current time printed in a cell whenever I print out a worksheet?

Thanks for your help.

Posted by Eric on August 24, 2001 12:43 PM

Print Header

Go to print preview, click setup button, select "Header/Footer" tab, click "custom header", put your cursor in one of the three sections (left, middle, or right) and hit the yellow clock symbol (5th symbol from left in "header" dialogue box). &[Time] should appear in the section you selected. Hit OK twice and the time on your computer should display in the header of the print preview sheet.
Hope that helps