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
- And if you convert it to a range name you can use it in all sorts of useful ways. (I’ll be covering that in other tutorials)
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
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/creating_a_table.mp4′]