Excel Shortcuts

BY STANLEY ZAROWIN

EXCEL SHORTCUTS
Format numbers:
    General—Ctrl+Shift+~
    Currency—Ctrl+Shift+$
    Percentage—Ctrl+Shift+%
    Date (d, m, y)—Ctrl+Shift+#
Work in a range:
    Select current range—Ctrl+*
    Move to range border—Ctrl+arrow
    Move down—Enter
    Move up—Shift+Enter
    Move right—Tab
    Move left—Shift+Tab

Stanley Zarowin is a contributing editor to the JofA. His e-mail address is stanley.joatech@gmail.com .

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to me via e-mail at stanley.joatech@gmail.com or via regular mail at the Journal of Accountancy, 220 Leigh Farm Road, Durham, NC 27707-8110.

Because of the volume of mail, I regret I cannot individually answer submitted questions. However, if a reader’s question has broad interest, I will answer it in a forthcoming Technology Q&A column.

 

©2007 AICPA

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.