Excel Tips

Entering Dates

To enter today's date in a cell of your Excel spreadsheet just hold the CTRL key and press ; to enter the time CTRL/SHIFT and press :

If you want the day's date to appear and change each time you open your spreadsheet, use the formula =now() formatting the cell to show a date. If you format the cell to show a time, it will show the time when the workbook was last opened.

Inserting/Deleting Rows

You can delete a row or column quickly in Excel. Select the row or column you wish to delete or use Shift [Space] to select an entire row; use CTRL [Space] to select an entire column. After selecting a row or column, use CTRL [-] to delete a row or column quickly.

To Insert a row or column, after selecting a row or column, use CTRL [+].