Skip to content
# Excel 2016

###
Excel 2016 – How to exclude (blank) values from pivot table

If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
###
Excel 2016 – Formula to calculate age group from age

The following formulas show how to calculate an age group from an age. This may be useful if you need...
###
Excel 2016 – Auto-sum not working until edit formula or save spreadsheet

Problem When updating an Excel spreadsheet, formulas do not update automatically as values are entered or updates. Instead – the...
###
Excel 2016 – How to delete all empty columns

The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does...
###
Excel 2013/2016 – How to split comma separated values into columns

The following steps show how to split comma separated values from one column into many. In this example we’ll focus...
###
Excel 2013/2016 – How to change CSV delimiter character

By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter...
###
Excel 2016 – How to delete empty rows

The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does...
###
Excel 2016 – How to edit worksheet header/footer

The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on...
###
Excel wont allow insert new rows

Problem In an Excel document, you’re unable to insert a new row. The ‘Insert’ option is greyed out. Solution This...
###
Excel 2016 – How to filter pivot table data

The steps below will show how to hide data from a pivot table based on the value. In this example...
###
Excel 2016 – What is #DIV/0! error and how to fix it?

The #DIV/0! error message means “divide by zero” – a division which is mathematically impossible, hence the error. When you see...
###
Excel – How to calculate the difference between two dates

The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months...
###
How to create named cell references in Excel 2016

Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or...
###
Excel 2016 – How to force force value in formula

Problem One of the more frustrating features in Excel is its ability to automatically change a cells format – based...
###
How to calculate percent of total using Microsoft Excel

In these examples we’re going to show how to calculate the percent of a total using Microsoft Excel. The basic...