- 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
Reputation, security, compliance: Why AI risk disclosures are surging
AICPA releases gen AI tool: Josi
Reflecting on AI’s rise in accounting, looking to what comes next
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: