Microsoft Office Tutorials and References
In Depth Information
Finding people in your address book
The Filter button at the top of the City column shows a funnel (shown in Figure
4.13), so you can see that the spreadsheet is being ﬁ ltered by that column. To turn
the ﬁ lter off again, click to open that menu and then click the tickbox for Select
All. You can also click the Sort & Filter button on the ribbon and click Filter on the
menu again to switch all the ﬁ lters off.
You can use ﬁ lters on different columns at the same time: for example, you could
ﬁ lter by both last name and country if you wanted to see all the people from the
same family in Australia.
When you save your ﬁ le, any ﬁ lters that are on will be saved with it. That can be
confusing when you open it again and see that some of the data’s missing, so it’s
a good idea to remove any ﬁ lters before you save the document.