Excel (Microsoft Excel) has an extensive range of shortcuts, which are listed below:
- You can also follow us on [color=#1E00A3]AutomationForum.co[/color], [url= https://www.facebook.com/instrumentation.control][color=#1E00A3]Facebook[/color][/url] and [url= https://www.linkedin.com/showcase/81532759/feed/posts/][color=#1E00A3]Linkedin[/color][/url] to receive daily Instrumentation updates.
- You can also follow us on [color=#1E00A3] ForumElectrical.com [/color], [color=#1E00A3] Facebook [/color] and [color=#1E00A3] Linkedin[/color] to receive daily Electrical updates.
[color=#21855c]Navigation[/color]
- 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
[color=#21855c]Selection[/color]
- 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
[color=#21855c]Editing[/color]
- 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
[color=#21855c]Formatting[/color]
- 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
[color=#21855c]Formulas[/color]
- =: 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)
[color=#21855c]Data Management[/color]
- 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
[color=#21855c]Charts[/color]
- 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
[color=#21855c]Shortcuts for Working with PivotTables[/color]
- 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
[color=#21855c]Shortcuts for Working with Macros[/color]
- Alt + F8: Open the macro dialog box
- Alt + F11: Open the Visual Basic Editor
- Ctrl + Shift + F11: Run a macro
[color=#21855c]Other[/color]
- 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.
