- column
- TECHNOLOGY Q&A
Excel Shortcuts
Please note: This item is from our archives and was published in 2010. It is provided for historical reference. The content may be out of date and links may no longer function.
Related
Shaping AI governance and controls
Simple but effective AI use cases for CAS
How CPAs can use exponential smoothing in Excel for better forecasts
TOPICS
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: