Select Page

## Why you will never size Excel columns correctly

No better time to learn about the weird and wonderful: how Excel measures stuff. If you have ever tried to fit your spreadsheet columns to fit exact measurements in inches or centimetres and have failed before, this short post explains measurement units in Excel and...

## Checking that dates are in sequential order with Excel Conditional Formatting Formula

Question: I’m trying to figure out how to use conditional formatting to check if the date column is in sequential order and highlight a cell if it is not. Answer: Here is how you can create a conditional formatting rule which would highlight dates or numbers out...

## Comment Excel formulas with the N() function

Three-in-one today. That’s right, today you will discover one shortcut to add a comment to an Excel formula, discover how to use the N() function to add a comment and learn about N(). Using comments provides potential users -and yourself- with additional...

## Friday Fun: Spreadsheet Heroes to the Rescue

You can’t PivotTable stuff all day long! So here is a selection of three pieces of Excel art which will amuse you, amaze you, surprise you. Pow! Bang! #N/A! #N/A! #N/A! #N/A! Batman! This one will rescue you if your workbook is full of errors. Oh, oh, oh! Sweet...

## Insert the current date or time quickly without looking at your watch with today’s Excel tip

If you have to frequently enter the current date and time into your spreadsheet e.g. in a log or diary entry, there’s a quick way to do it without having to type the date, time or even looking at your watch as shown in today’s tip. In a cell Press...