|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Excel > Worksheets | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| 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 | - | Office Online |
| More Details | - | Knowledge Base |
Shortcut Keys |
(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. |
Tools > 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 Topics |
| GoTo | - | Cells & Ranges |
| GoTo | - | Protection |
| Copyright © 2010 Better Solutions Limited. All Rights Reserved. | Top |