Call us on 01223 214177 or email us
Have you ever struggled to read the data in an Excel spreadsheet and you find 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.
Here's how:
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.