Excel Tip – The Format of an Inserted Column

Un-beknown to most, when you insert a new column, the Format of the cells in the Column are of the cells in the Column on the Left. So, if you get a Date when you enter a number as with the example shown, you would have inserted the column to the right of a Date Formatted Field. This can be useful if that was your intention, but most of the time it isn’t. To override this default, use the Insert Options (little Paintbrush) to change the Format; either to the Column on the right or Clear the Formatting altogether.

Excel Tip – Entering the Current Date and Time

A reminder of 2 very useful keyboard shortcuts! Ctrl + ; Current Date Ctrl + shift + ; Current time These shortcuts will enter hardcoded values and will therefore not change on future days. If you dynamically need to assign the current Day and / or Time to a cell or Formula you can use the following Functions: =Today() Current Date =Now() Current Date and Time NB! =Now() gives you the current Date and Time, where-as Ctrl + shift + ; only gives you the time with the Date component effectively being zero. This is important to note if you’re computing with these as the underlying values are very different. To explain this further: Remember that the

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923


Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions