In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to quickly format and enable filtering of your data (Excel 2007 onwards)...
Tame your computer - fancy formats and filters
Have you ever struggled to read the data in an Excel spreadsheet and found yourself using a piece of paper as a ruler to ensure you are matching up the data on the same line? Do you still switch on the filtering functionality, using Excel’s Filter button?
Since Excel 2007 you can quickly turn a range of cells into something resembling stock listing paper that mainframe computers used to churn out (remember those faint green horizontal lines?) and enable the filtering functionality.
- Click anywhere in the data that is to be formatted and analysed.
- Press CTRL + L. (A table used to be called a list, hence the L.)
- Press ENTER. (If your data does not contain headers, first tick the check box.)
If you don’t like the default style, rummage through the various predefined table styles, not forgetting the More button in the bottom left hand corner. A sizing handle in the lower-right corner of the table allows you to drag the table to the size that you want.
Click the arrow in the column header to choose a filter so that you display only those records containing the data you want.
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing firstname.lastname@example.org - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
9 September 2014
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at http://www.roem.co.uk
Please note: Cambridge Network and Learning Collaboration members have the opportunity to book places on Roem Ltd courses at a reduced rate.