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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
