Microsoft
Excel is a powerful tool used for data analysis, financial modelling, and
general spreadsheet tasks. Knowing keyboard shortcuts can significantly enhance
productivity by speeding up navigation and execution of commands. Below is an
extensive guide to some of the most useful shortcuts in Excel.
Basic
Navigation Shortcuts
1.
Arrow Keys: Move one cell up, down, left, or right.
2.
Ctrl + Arrow Keys: Jump to the edge of data in the current row or
column.
3.
Tab: Move one cell to the right.
4.
Shift + Tab: Move one cell to the left.
5.
Enter: Move one cell down.
6.
Shift + Enter: Move one cell up.
7.
Page Up/Page Down: Move one screen up or down.
8.
Alt + Page Up/Alt + Page Down: Move one screen to the left or
right.
9.
Ctrl + Home: Move to the beginning of the worksheet.
10.
Ctrl + End: Move to the last cell with data.
Cell Selection
Shortcuts
1.
Shift + Arrow Keys: Select a range of cells.
2.
Ctrl + Shift + Arrow Keys: Select a large range of cells, extending
the selection to the edge of the current data region.
3.
Ctrl + A: Select the entire worksheet or the current data region.
4.
Shift + Space: Select the entire row.
5.
Ctrl + Space: Select the entire column.
6.
Ctrl + Shift + Space: Select the entire worksheet.
Data Entry
Shortcuts
1.
Ctrl + D: Fill down the contents of the top cell in the selected
range to the other cells in the range.
2.
Ctrl + R: Fill right the contents of the leftmost cell in the
selected range.
3.
Ctrl + Enter: Fill the selected cells with the current entry.
4.
Alt + Enter: Start a new line within the same cell.
5.
Ctrl + ;: Enter the current date.
6.
Ctrl + Shift + :: Enter the current time.
7.
Ctrl + `: Toggle the display of formulas.
Editing
Shortcuts
1.
F2: Edit the active cell.
2.
Ctrl + Z: Undo an action.
3.
Ctrl + Y: Redo an action.
4.
Delete: Clear the contents of the selected cell.
5.
Ctrl + -: Delete the selected cells.
6.
Ctrl + Shift + +: Insert cells.
7.
Ctrl + C: Copy the selected cells.
8.
Ctrl + X: Cut the selected cells.
9.
Ctrl + V: Paste the copied or cut cells.
10.
Ctrl + Alt + V: Open the Paste Special dialog box.
11.
F4: Repeat the last action.
12.
Ctrl + 1: Open the Format Cells dialog box.
Formatting
Shortcuts
1.
Ctrl + B: Apply or remove bold formatting.
2.
Ctrl + I: Apply or remove italic formatting.
3.
Ctrl + U: Apply or remove underline formatting.
4.
Alt + H, A, C: Centre align cell contents.
5.
Alt + H, A, L: Align cell contents to the left.
6.
Alt + H, A, R: Align cell contents to the right.
7.
Ctrl + Shift + $: Apply currency format.
8.
Ctrl + Shift + %: Apply percentage format.
9.
Ctrl + Shift + ^: Apply scientific number format.
10.
Ctrl + Shift + #: Apply date format.
11.
Ctrl + Shift + @: Apply time format.
Formula
Shortcuts
1.
=: Start a formula.
2.
Ctrl + Shift + Enter: Enter an array formula.
3.
Alt + =: Insert the SUM function.
4.
Ctrl + `: Toggle the display of formulas.
Function Key
Shortcuts
1.
F1: Open Help.
2.
F2: Edit the active cell.
3.
F3: Paste a defined name into a formula.
4.
F4: Repeat the last action.
5.
F5: Open the Go To dialog box.
6.
F6: Switch between the worksheet, Ribbon, task pane, and Zoom
controls.
7.
F7: Open the Spelling dialog box.
8.
F8: Turn on/off Extend Selection mode.
9.
F9: Calculate all worksheets.
10.
F10: Activate the Menu bar.
11.
F11: Create a chart.
12.
F12: Open the Save As dialog box.
Special
Shortcuts
1.
Ctrl + F1: Expand or collapse the Ribbon.
2.
Ctrl + F2: Open Print Preview.
3.
Ctrl + F3: Open the Name Manager.
4.
Ctrl + F4: Close the window.
5.
Ctrl + F6: Switch to the next workbook window.
6.
Ctrl + F9: Minimize the workbook window.
7.
Ctrl + F10: Maximise or restore the workbook window.
Miscellaneous
Shortcuts
1.
Alt + F8: Open the Macro dialog box.
2.
Alt + F11: Open the Visual Basic for Applications editor.
3.
Shift + F2: Add or edit a cell comment.
4.
Ctrl + 9: Hide selected rows.
5.
Ctrl + 0: Hide selected columns.
6.
Ctrl + Shift + ( (Ctrl + Shift + 9): Unhide hidden rows.
7.
Ctrl + Shift + ) (Ctrl + Shift + 0): Unhide hidden columns.
These
shortcuts are essential for efficient Excel use, enabling users to navigate
quickly, format cells, enter and edit data, use formulas, and manage workbooks
effectively. Mastery of these shortcuts can greatly improve productivity and
accuracy in handling spreadsheet tasks.