# Excel Shortcuts (Microsoft Excel Shortcuts)

**URL:** <https://forumautomation.com/t/excel-shortcuts-microsoft-excel-shortcuts/12509>\
**Category:** Software and Tools\
**Tags:** software-design\
**Created:** [August 30, 2024, 2:37pm UTC](https://forumautomation.com/t/excel-shortcuts-microsoft-excel-shortcuts/12509 "2024-08-30T14:37:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rabert](https://forumautomation.com/user_avatar/forumautomation.com/rabert/32/6784_2.png) [@Rabert](https://forumautomation.com/u/Rabert)\
**Post date:** [August 30, 2024, 2:37pm UTC](https://forumautomation.com/t/excel-shortcuts-microsoft-excel-shortcuts/12509/1 "2024-08-30T14:37:19Z")

</div>

**Excel (Microsoft Excel)** has an extensive range of shortcuts, which are listed below:

- You can also follow us on [[color=#1E00A3] **AutomationForum.co** [/color]](https://automationforum.co/), [url= [https://www.facebook.com/instrumentation.control](https://www.facebook.com/instrumentation.control)][color=#1E00A3] **Facebook** [/color][/url] and [url= [https://www.linkedin.com/showcase/81532759/feed/posts/](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]](https://forumelectrical.com/), [[color=#1E00A3] **Facebook** [/color]](https://www.facebook.com/profile.php?id=100091841583670) and [[color=#1E00A3] **Linkedin** [/color]](https://www.linkedin.com/showcase/91130242/feed/posts/) 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.

 ![image](https://cdn.forumautomation.com/original/2X/a/a339abbbef134444bc747cadb23f0dcc82a77ea8.jpeg)
