Excel Shortcuts
Ctrl+Shift+) unhides any hidden columns within the selection.
Ctrl+Shift+( unhides any hidden rows.
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 number 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 date format with the day, month and year.
Ctrl+Shift+@ applies the time format with the hour and minute. If there is no time element in the date, the shortcut assumes 12 a.m.
Ctrl+Shift+! applies the number format with two decimal places, thousands separator and minus sign (-) for negative values.
More from the JofA:
