Print the Current Date or Time in Excel

Add to Favorites
Author: don

How to print the current date and or time on an Excel spreadsheet.

This is a simple technique that allows you to display the date and or time in the footer or header of the spreadsheet without it being visible when working in Excel.

Steps to Print the Date/Time in Excel

  1. Go to the View tab and click the Page Layout button.
  2. Now, you will see the spreadsheet divided into pages, which is how it will look when it is printed.  Click the top of the page to add a header, where is says "Click to add header", or the bottom to add a footer, where it says "Click to add footer".

    I will add the date/time in the footer.  When you do this, you can click the middle, left, or right side, depending on where you want the data to appear in the footer.

  3. Once you click in the footer, a new tab called Design should have opened up with options for what you can put into the footer and header.  Let's click Current Date and then hit the space bar to put a space before the time and then click Current Time.

  4. If we now go to Print Preview, we can see the date and time at the bottom of our page.

Notes

This is a very simple feature yet it can be very helpful.  Often, this can eliminate the need for displaying a date/time inside the worksheet, which, in order to make current, takes a little programming

Make sure to download the sample workbook so you can see this example in action.

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Similar Content on TeachExcel
Format Cells in The Short Date Number Format in Excel
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
Format Cells in The Long Date Number Format in Excel
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Top Excel Keyboard Shortcuts to Increase Productivity
Tutorial: I'll show you the top keyboard shortcuts for Excel that are sure to increase your producti...
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Get the Current Date in Excel
Tutorial: How to get the current date using Excel.  This method updates the date every day so that i...
NOW() - Display The Current Time in Excel
Tutorial: This Excel tip will show you how to display the current time within any Excel spreadsheet....
Tutorial Details
Downloadable Files: Excel File
Similar Content
Format Cells in The Short Date Number Format in Excel
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
Format Cells in The Long Date Number Format in Excel
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Top Excel Keyboard Shortcuts to Increase Productivity
Tutorial: I'll show you the top keyboard shortcuts for Excel that are sure to increase your producti...
Excel Forum