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.

-1
Ctrl + ↑  Shift + F

Opens the Format Cells dialog box with the Font tab selected

0
Ctrl + G

Displays the Go To dialog box

0
or F5
0
Ctrl + H

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

1
Ctrl + I

Applies or removes italic formatting

0
Ctrl + K

Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlinkdialog box for selected existing hyperlinks

0
Ctrl + N

Creates a new, blank workbook

0
Ctrl + O

Displays the Open dialog box to open or find a file

-4
Ctrl + ↑  Shift + O

Selects all cells that contain comments

0
Ctrl + P

Displays the Print dialog box

0
Ctrl + ↑  Shift + P

Opens the Format Cells dialog box with the Font tab selected

-1
Ctrl + R

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right

0
Ctrl + S

Saves the active file with its current file name, location, and file format

0
Ctrl + T

Displays the Create Table dialog box

0
Ctrl + U

Applies or removes underlining

0
Ctrl + ↑  Shift + U

Switches between expanding and collapsing of the formula bar

0
Ctrl + V

Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents

0
Ctrl + Alt + V

Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program

0
Ctrl + W

Closes the selected workbook window

0
Ctrl + X

Cuts the selected cells

1
Ctrl + Y

Repeats the last command or action, if possible

0
Ctrl + Z

Uses the Undo command to reverse the last command or to delete the last entry that you typed

5
Ctrl + ↑  Shift + Z

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

Advertisement

0
↑  Shift +

To open a template as a template file and edit it (instead of saving it as .xlsx), right click the file and Shift (plus) click to "Open" menu item

0
Ctrl + J

You can use this shortcut to split cells with multiple rows into columns with Alt + Enter while converting text to columns. Go to Data > Convert text to columns > Delimited and click "More" box then press Ctrl + J


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 your list of 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!