KEMBAR78
Excel Keyboard Shortcuts Guide | PDF | Microsoft Excel | Software Engineering
Scribd
Upload
51 views2 pages

Excel Keyboard Shortcuts Guide

This document summarizes keyboard shortcuts for navigation, functions, and formatting in Excel. Some key navigation shortcuts include Control + Home to go to cell A1, Control + arrows to move between cells, and Control + Space/Shift + Space to select entire columns/rows. Common functions are accessed with Control combinations like Control + N for a new workbook, Control + S to save, and Control + C/V to copy and paste. Formatting shortcuts make text bold, italic, or underlined using Control + B, I, or U respectively.

Uploaded by

Prajwal S
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
51 views2 pages

Excel Keyboard Shortcuts Guide

This document summarizes keyboard shortcuts for navigation, functions, and formatting in Excel. Some key navigation shortcuts include Control + Home to go to cell A1, Control + arrows to move between cells, and Control + Space/Shift + Space to select entire columns/rows. Common functions are accessed with Control combinations like Control + N for a new workbook, Control + S to save, and Control + C/V to copy and paste. Formatting shortcuts make text bold, italic, or underlined using Control + B, I, or U respectively.

Uploaded by

Prajwal S
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Navigation

Control + Home Takes you back to cell A1


Control + End Takes you to the furthest active cell
Shift + Right arrow Selects cells across to the right
Shift + Down arrow Selects cells going down
Control + Right arrow Takes you to the last cell to the right of the current data region
Control + Down arrow Takes you to the last cell at the bottom of the current data region

Control + Shift + Right arrow Extends the selection to the last cell of a range to the right
Control + Shift + Down arrow Extends the selection to the last cell of a range going down
Control + Space bar Selects the whole column
Shift + Space bar Selects the whole row
Control + Page up Switches between worksheets to the right
Control + Page down Switches between worksheets to the left
Control + Tab Switches between workbooks
Alt + Tab Switches between applications
Control + A Selects all the cells in a worksheet
Escape Gets you out of the menu/function you are in

Additional Functions
F1 Excel help
F2 Makes cells active for editing without the mouse
F2 (alternative) Shows the source data for formulas in the cell
F4 Adds dollar signs to make references absolute
F4 (alternative) Re-does the last formatting action to the cell
F5 Go to function - takes you to certain cells
Alt key Wakes up the ribbon menus
Control + F1 Hides the ribbon
Alt + = Sums a formula
Basic Functions
Control + N Opens a new workbook
Control + S Saves a workbook
F12 Save as
Control + O Opens a workbook
Control + C Copy
Control + V Paste

Control + X Cut
Control + Z Undo
Control + Y Redo
Control + P Opens the Print menu
Control + F Find cell contents
Control + H Replace cell contents
Control + R Copies a formula to the right
Control + D Copies a formula down
Control + W Closes the workbook
Shift + F2 Inserts a comment
Shift + F11 Inserts a new worksheet

Basic Formatting
Control + B Makes the contents of the cells bold
Control + I Makes the contents of the cells italics
Control + U Underlines the contents of the cell
Shift + F11 Inserts a new worksheet
Control + 1 Opens the Format Cells menu
Delete Clears the contents of a cell

You might also like