Excel Shortcuts

BY STANLEY ZAROWIN

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:

 

 Find us on Facebook      Follow us on Twitter

 

SPONSORED REPORT

A new line of business to consider

Technology assessments may open the door to new engagement opportunities for your firm. What is a technology assessment? How do you perform one? JofA Tech Q&A author J. Carlton Collins shows you in a detailed explanation.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.