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.