- 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
Ancient Greece to AI: The past and future of bank fraud
What to know about AI guardrails, leasehold improvements, and the latest ASB developments
AI tools for finance professionals to prepare and visualize data
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: