|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft 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 |
Advanced |
| More Details | - | Advanced Filter |
| More Details | - | Advanced Filter - Copying |
| More Details | - | Advanced Filter - Unique Records |
| More Details | - | Using Named Ranges |
| More Details | - | List Toolbar |
| More Details | - | List Objects |
| 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 © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |