Microsoft Excel 2019 keyboard shortcuts

Microsoft Excel 2019  

Zeynel -
6 years ago
- Shortcuts

Excel shortcuts will help you work on your spreadsheets more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse.

0
Ctrl + W

Close a workbook

1
Alt + H

Go to the Home tab

2
Alt + A

Go to Data tab

1
Ctrl + ↑  Shift + F3

Create names from selection

Advertisement

1
Ctrl + F1

Expand or collapse the ribbon

0
Ctrl + ↑  Shift + End

Extend the selection of cells to the last used cell on the worksheet (lower-right corner)

4
Ctrl + Home

Move to the beginning of a worksheet

1
Ctrl + ↑  Shift + +

Open the Insert dialog to insert blank cells

3
Ctrl + Alt + V

Open the Paste Special dialog box

4
Ctrl + D

Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below

0
↑  Shift +

Extend the selection of cells by one cell

2
Alt + ⤶ Enter

Start a new line in the same cell

3
Ctrl + ⤶ Enter

Fill the selected cell range with the current entry

3
Ctrl + ↑  Shift + U

Expand or collapse the formula bar

0
Ctrl + ↑  Shift + A

Insert argument names and parentheses when the insertion point is to the right of a function name in a formula

4
Ctrl + E

Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column

2
Alt + F8

Create, run, edit, or delete a macro

0
Alt + F11

Open the Microsoft Visual Basic For Applications Editor

For example, Alt, W, P switches the worksheet to Page Layout view.
3
Ctrl + F

Displays the Find and Replace dialog box, with the Find tab selected

5
Ctrl + ↑  Shift + Z

Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed


Share this page on:
Is this page helpful?
0 0

Program information

Program name: Microsoft Excel 2019 Microsoft Excel 2019 (Productivity)

Microsoft Excel is a spreadsheet application which features calculation, graphing tools, pivot tables and macro programming language. Initially released on 1987, Excel is a part of Microsoft Office. In addition to Windows, it also has support for macOS, Android and iOS.

Web page: office.microsoft.com/excel

Last update: 7/13/2021 8:36 PM UTC

How easy to press shortcuts: 81%

More information >>

Updated: Added some shortcuts. (9 updates.) 2/1/2021 7:14:05 PM Added some shortcuts.
2/1/2021 7:17:43 PM Added some shortcuts.
2/17/2021 10:31:52 AM Added some shortcuts.
2/17/2021 10:32:22 AM Added some shortcuts.
7/13/2021 10:29:57 PM Added some shortcuts.

Shortcut count: 312

Platform detected: Windows or Linux

Similar programs



User operations

Add Microsoft Excel 2019 to favorites

Add to favorites

Advertisement


What is your favorite Microsoft Excel 2019 hotkey? Do you have any useful tips for it? Let other users know below.


 
? Guest OP says : 4 years ago 7/3/2020 10:34 AM
so good! thank you so much!