»
New Filter Options
New to Excel 2007 is the ability to filter data based on cell color. So, for example, where you have used conditional formatting to color a range of cells different colors according to the values in the cells, you can filter on these colors. To do this, click the Filter button for the column containing the colored cells and choose Filter by Color and then select the color to filter on.
Excel 2007 also has new Date filtering options. Where you have a column containing dates, you will see that, instead of listing all the dates in the dialog you can filter by year or month or day as desired. You can also use the Date Filters option and select from a number of preset date options such as This Month, Last Month, Year to Date and so on.
»
Copying Filtered Data
When you have filtered the data in a worksheet you will encounter problems if you try to copy the data. All the cells are selected and copied by default, not just those which are visible.
To select and copy only the visible cells, select the area to copy, and from the Home tab on the Ribbon, click the Find & Select button, select Go to Special > Visible Cells Only, and then click OK. Now when you copy and paste the data only the cells which were visible on the worksheet will be copied.
Helen Bradley is a respected international journalist writing regularly for small business and computer publications in the USA, Canada, South Africa, UK and Australia. She blogs at http://www.projectwoman.com/blogger.html.
Be sure to check out all of Helen's articles in the Exploring Office 2007 series:
