Excel – Intermediate

One Step Further
Let’s make finding the correct row a bit easier

You will need to have a document with headings ie on the first row each column needs to have a title for that data that belongs underneath it (eg firstname OR telephone).

Left-click on the A1 cell
choose from the top-most toolbar ‘Data’ ‘Filter’ ‘Autofilter’

Each column heading has now an arrow on the right side of it. If you click on it you can choose which row of data it will show you! You’ll get back to seeing everything by clicking the same arrow and choosing ‘All’