Microsoft Office Development and Consultancy

Excel

Basic

 -

Getting Started

 -

Displaying Sheets

 -

Navigating Sheets

 -

Renaming Sheets

 -

Inserting Sheets

 -

Deleting Sheets

 -

Copying Sheets

 -

Moving Sheets

 -

Grouping Sheets

 -

Hiding Sheets

 -

Colouring Sheet Tabs

 -

Edit > Find Dialog Box

 -

Edit > Replace Dialog Box

 -

Edit > Undo / Repeat

Advanced

 -

Split Screens

 -

Windows

 -

Custom Views

 -

Comparing Worksheets

 -

Consolidating Worksheets

 -

Advanced Techniques

 -

Version Changes

 -

Office Online

 -

Knowledge Base

 -

Knowledge Base - Numerical

 -

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

 -

Cells & Ranges

 -

Rows & Columns