If you find that users are consistently entering incorrect data into worksheets then using Data Validation to prevent users entering invalid data and also displaying a message to prevent them is the...

Here is another fab Excel tip. Excel is kind of clever as if you didn't already know.  Excel will automatically fit your data to your cells by shrinking it.  The data in the cell is fitted...

If you have a large worksheet with a lot of data then finding exactly what you are looking for can be problematic. The Excel Find And Replace dialog box is the most useful tool for this...

Whilst using Excel there will be a good number of scenarios where you want to find the number of unique values you have in a range of cells.  this could be Customer Names, Invoice Numbers, Order...

If you frequently use Microsoft Excel, you might have come across the need to merge cells in your worksheet to make it more presentable or easier to read. However, sometimes, these merged cells can...

This is one of my favorite EVER timesaving Excel Tips Need to quickly select all of the cells that contain data in your worksheet? This could be for formatting, or a a selection of data for a...