Data Menu
Menu | Excel 2003 Location | Excel 2007 Location |
---|---|---|
Data | Sort | Data tab, Sort & Filter group, Sort command |
Data | Filter | Data tab, Sort & Filter group, Filter command |
Data | Filter, AutoFilter | Home tab, Editing group, Sort & Filter, Filter command |
Data | Filter, Show All | Data tab, Sort & Filter group, Clear command |
Data | Filter, Show All | Home tab, Editing group, Sort & Filter, Clear command |
Data | Filter, Advanced Filter | Data tab, Sort & Filter group, Advanced command |
Data | Form | You must add a button to the Quick Access Toolbar for this command: Microsoft Office Button, Excel Options, Customize category, All Commands, Form |
Data | Subtotals | Data tab, Outline group, Subtotal command |
Data | Validation | Data tab, Data Tools group, Data Validation command |
Data | Table | Data tab, Data Tools group, ... |
Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.