Excel 2003 Data Menu
|
Excel 2003 Data Menu Command |
Excel 2010 Location and Command |
|---|---|
|
Sort |
Data tab, Sort & Filter group, Sort command |
|
Filter |
Data tab, Sort & Filter group, Filter command |
|
Filter, AutoFilter |
Home tab, Editing group, Sort & Filter, Filter command |
|
Filter, Show All |
Data tab, Sort & Filter group, Clear command |
|
Home tab, Editing group, Sort & Filter, Clear command | |
|
Filter, Advanced Filter |
Data tab, Sort & Filter group, Advanced command |
|
Form |
You must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, Form |
|
Subtotals |
Data tab, Outline group, Subtotal command |
|
Validation |
Data tab, Data Tools group, Data Validation command ... |
Get Microsoft® Excel® 2010 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.
