AppendixKeyboard shortcuts

Following is a comprehensive list of shortcuts derived from Excel 2019 Help. Some shortcuts might not be available in every edition of Excel 2019.

Ctrl-combination shortcut keys

Key

Description

Ctrl+Shift+)

Unhides any hidden columns within the selection.

Ctrl+Shift+(

Unhides any hidden rows within the selection.

Ctrl+Shift+&

Applies the outline border to the selected cells.

Ctrl+Shift+_

Removes the outline border from the selected cells.

Ctrl+Shift+~

Applies the General format.

Ctrl+Shift+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

Ctrl+Shift+%

Applies the Percentage format with no decimal places.

Ctrl+Shift+^

Applies the Scientific format with two ...

Get Microsoft Excel 2019 Step by Step, First Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.