![]() |
Microsoft Office Development and Consultancy |
| Home | | | Excel | | | VBA | | | C# | | | Finance | | | Tools | | | Newsletter | | | Feedback | | | Contact |
| Excel > Worksheets | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| Step By Step | - | Displaying Sheets |
| Step By Step | - | Navigating Sheets |
| Step By Step | - | Renaming Sheets |
| Step By Step | - | Inserting Sheets |
| Step By Step | - | Deleting Sheets |
| Step By Step | - | Copying Sheets |
| Step By Step | - | Moving Sheets |
| Step By Step | - | Grouping Sheets |
| Step By Step | - | Hiding Sheets |
| Step By Step | - | Colouring Sheet Tabs |
| Step By Step | - | Edit > Find Dialog Box |
| Step By Step | - | Edit > Replace Dialog Box |
| Step By Step | - | Edit > Undo / Repeat |
Advanced |
| More Details | - | Split Screens |
| More Details | - | Windows |
| More Details | - | Custom Views |
| More Details | - | Comparing Worksheets |
| More Details | - | Consolidating Worksheets |
| More Details | - | Advanced Techniques |
| More Details | - | Version Changes |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
| More Details | - | Knowledge Base - Numerical |
| More Details | - | VBA Code |
Shortcut Keys |
(Ctrl + Shift + End) - Extends the selection to the last used cell on the worksheet. | ||
(Ctrl + Page Up) - Moves to the previous worksheet in the active workbook. | ||
(Ctrl + Page Down) - Moves to the next worksheet in the active workbook. | ||
(Ctrl + ' ) - Toggles between the Value layer and the Formula layer. | ||
(Shift + F9) - Calculates the active worksheet. | ||
(Shift + F11) - Inserts a new worksheet before the active worksheet. | ||
(Alt + Shift + F1) - Inserts a new worksheet before the active worksheet. |
Options |
(View tab, Formulas) - Displays all the formulas on the active worksheet. All the columns will double in width. | ||
(View tab, Gridlines) - Toggles the display of gridlines on the active worksheet. | ||
(View tab, Zero Values) - Displays a number zero in any cells that contain a zero value. |
Related Sections |
| GoTo | - | Cells & Ranges |
| GoTo | - | Rows & Columns |
| © Better Solutions Limited 10-May-2013 | Top |