|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Excel > Lists | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| Step By Step | - | AutoComplete |
| Step By Step | - | Automatic Formats and Formulas |
| Step By Step | - | Sorting Lists |
| Step By Step | - | AutoFilter |
| Step By Step | - | AutoFilter - Number of Rows |
| Step By Step | - | AutoFilter - Top 10 |
| Step By Step | - | AutoFilter - Custom |
| Step By Step | - | Advanced Filter |
| Step By Step | - | Advanced Filter - Copying |
| Step By Step | - | Advanced Filter - Unique Records |
Excel 2003 |
| More Details | - | Creating a List |
| More Details | - | List Toolbar |
Excel 2007 |
| More Details | - | Creating a Table |
Advanced |
| More Details | - | Using Named Ranges |
| More Details | - | Advanced Techniques |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
Shortcut Keys |
(Ctrl + Shift + A) - Applies the AutoFilter to the current region. | ||
(Alt + Down Arrow) - Display the AutoFilter list for the current column. | ||
(Alt + Up Arrow) - Closes the AutoFilter list for the current column. |
Tools > Options |
(Edit tab, Extend data range formats and formulas) - Formulas that contain references to ranges will be automatically expanded when new cells are inserted to the right or below the existing range. This only works when cells are inserted immediately below or to the right of a referenced range. |
Related Topics |
| GoTo | - | Cells & Ranges |
| GoTo | - | Database |
| Copyright © 2010 Better Solutions Limited. All Rights Reserved. | Top |