## Excel 2016 – How to have pivot chart show only some columns

The following steps show how to create a pivot table and chart that has two values (value and percent of total) but the chart only displays one value. This process…

Skip to content
## Excel

## Excel 2016 – How to have pivot chart show only some columns

## How to export Outlook auto-complete to Excel list

## The idiots guide to installing WordPress on DigitalOceans $5 a month plan

## Excel 2013/2016 – How to change CSV delimiter character

## Excel 2013/2016 – How to split comma separated values into columns

## Excel 2013 – How to create drop down lists

## Excel 2016 – Auto-sum not working until edit formula or save spreadsheet

## Excel 2016 – How to delete all empty columns

## Excel 2016 – How to delete empty rows

The following steps show how to create a pivot table and chart that has two values (value and percent of total) but the chart only displays one value. This process…

In Outlook when you send an email the address is remembered and added to an 'auto-complete' list. The next time you type the email address into the 'to' field (as…

I'm not interested in getting into the technical aspects of setting up a VPS as a web server - instead I choose to use DigitalOcean and ServerPilot to get me…

By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter - hence the name Comma Separated Values (CSV). This can…

The following steps show how to split comma separated values from one column into many. In this example we'll focus on comma separated values, but the same process can be…

A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. This can be done to make data entry easier or to…

Problem When updating an Excel spreadsheet, formulas do not update automatically as values are entered or updates. Instead - the formula only updates after the formula is edited or the…

The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does not account for partially empty columns. For example if a…

The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does not account for partially empty rows. For example if a…