How to Insert a Static Date in Excel

By Techwalla Computers Editor

A static date is a date that never updates. A static date can easily be inserted into a Microsoft Excel 2007 spreadsheet. This static date can be inputted so you can record the current date or make any other note of a certain date that you don't want to be updated.

Things You'll Need

  • Microsoft Excel 2007

Step 1

Open Microsoft Excel 2007, and start a new spreadsheet that you would like to insert a static date into or open an existing spreadsheet from your files into which you want to insert a static date.

Step 2

Click to select the cell to which you want to insert the static date. The cell will then be surrounded by a thick, black outline indicating it is ready for you to insert the static date into it.

Step 3

Use your keyboard to enter the shortcut of "CTRL" + ";" into the selected cell. Both the "CTRL" key and the semicolon key must be pressed at the same time. This keyboard shortcut will tell Excel to enter a static date into the selected cell.

Step 4

Watch as the current date appears in the selected cell. This date will remain static, not being updated at any time during the life of the spreadsheet.

Step 5

Utilize the procedure that is outlined above to insert the static date into any other cells in the spreadsheet where you would like to display a static date.