Insert Date Or Time In Header Or Footer. But the Number item on menu is dimmed. Insert sheet Insert tab Text group Header Footer Select footer area Design tab Header Footer Elements group Current Date Insert separation sign Current Time Click anywhere on the sheet.
This is any chosen date entered by the author. Insert the current time in the header or footer On the View menu click Header and Footer. Click on Current Time in the Header Footer Elements group.
This will insert Time in the selected header area after the separation sign which will show the current time.
If you want to insert current date and time into worksheets header or footer you can go to Page Setup dialog. In the Header or Footer sections click in the Left Center or Right sections depending on where you want the date or. This may be further complicated by the fact that if the workbook has more than one worksheet you may not be able to tell which sheet got changed only if anything in the document got changed so it may be hard to tell which worksheet header to modify. In the Page Setup dialog click HeaderFooter tab then select Custom Header or Custom Footer as you need.
