Excel (Microsoft Excel) has an extensive range of shortcuts, which are listed below:
- You can also follow us on AutomationForum.co, Facebook and Linkedin to receive daily Instrumentation updates.
- You can also follow us on ForumElectrical.com , Facebook and Linkedin to receive daily Electrical updates.
Navigation
- Ctrl + Home: Go to cell A1
- Ctrl + End: Go to last cell with data
- Ctrl + Page Up/Page Down: Switch between worksheets
- Ctrl + Tab: Switch between open Excel files
- Ctrl + F6: Move to next worksheet
- Ctrl + Shift + F6: Move to previous worksheet
- Ctrl + F11: Toggle fullscreen mode
Selection
- Ctrl + A: Select all cells
- Ctrl + I: Select entire row
- Ctrl + Space: Select entire column
- Shift + Space: Select entire row
- Ctrl + Shift + Space: Select entire worksheet
- Ctrl + Shift + >: Select cells down to last cell with data
- Ctrl + Shift + <: Select cells left to last cell with data
Editing
- Ctrl + C: Copy
- Ctrl + X: Cut
- Ctrl + V: Paste
- Ctrl + Z: Undo
- Ctrl + Y: Redo
- F2: Edit cell
- Alt + Enter: Insert new line in cell
- Ctrl + Shift + >: Increase font size
- Ctrl + Shift + <: Decrease font size
Formatting
- Ctrl + 1: Format as number
- Ctrl + Shift + !: Format as time
- Ctrl + Shift + $: Format as currency
- Ctrl + B: Bold
- Ctrl + I: Italic
- Ctrl + U: Underline
- Ctrl + Shift + F: Font dialog box
- Ctrl + Shift + >: Increase font size
- Ctrl + Shift + <: Decrease font size
Formulas
- =: Start a formula
- F3: Paste a named range or formula
- Shift + F3: Open the formula builder
- Ctrl + Shift + Enter: Create an array formula
- F5: Go to a specific cell or range
- Ctrl + F5: Go to a specific cell or range (alternative)
Data Management
- Ctrl + Shift + Down Arrow: Select cells down to last cell with data
- Ctrl + Shift + Right Arrow: Select cells right to last cell with data
- Ctrl + : Delete row
- Ctrl + +: Insert row
- Alt + F1: Create a pivot table
- Ctrl + Shift + F11: Edit a chart
Charts
- F11: Create a chart
- Alt + F1: Create a pivot chart
- Ctrl + Shift + F11: Edit a chart
- Ctrl + Shift + >: Increase chart size
- Ctrl + Shift + <: Decrease chart size
Shortcuts for Working with PivotTables
- Alt + F1: Create a pivot table
- Ctrl + Shift + F11: Edit a pivot table
- Ctrl + Shift + >: Increase pivot table size
- Ctrl + Shift + <: Decrease pivot table size
Shortcuts for Working with Macros
- Alt + F8: Open the macro dialog box
- Alt + F11: Open the Visual Basic Editor
- Ctrl + Shift + F11: Run a macro
Other
- Ctrl + S: Save
- Ctrl + P: Print
- Ctrl + O: Open
- Ctrl + N: New workbook
- Ctrl + F: Find
- Ctrl + Shift + F: Replace
- Ctrl + Shift + >: Increase font size
- Ctrl + Shift + <: Decrease font size
Important Note: Note that the shortcuts you use may change based on the version of Excel you are using or the size of your operating system.
