How to Insert a Static Date in Excel
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
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.
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.
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.
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.
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.