Tables in Excel
One of my new favourite features in the “new” Excel is Tables. When you convert your list to a table you quickly do the following:
- Apply slick formatting
- Apply filters
- Enter a formula once and see it whiz down the rest of the column instantly
- As you move down the data set, the column headings get fixed which is very useful if you are dealing with large data sets.
So how does it work?
Simple, click in your list. Press Ctrl and T (or use Insert:Table) and that’s it. You’ve just made it into a table. Click on the link Using a table to download a file to work on…
Watch the video below to see how it works…Don’t forget if you click on the button on the right – it makes it full screen
If you want to do a deeper dive into Tables, you can check out my book on it – Tables in Excel