microsoft excel training courses london - Auto filter

Hi Richard,

To take the Autofilter off you can go into the Data menu down to Filter and where the AutoFilter has a tick on it you click on it and it will remove the filter.

The AutoFilter maintains the row order across the table, so when you order one column the rest should move with it. However if you highlight one column excel will only sort one column and leave the rest as they were.

Good luck

Tracy