Excel 2016 Sunday, 29 November 2015 by 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... 2 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 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 formula... 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 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 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 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 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 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 – 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 delete empty rows The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does... 2
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 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 formula...
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 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 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 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 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 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 – 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...