10 Excel shortcuts


1. The SUM function. Pressing Alt+= in the cell below a column of numbers inserts the SUM function and highlights that column of numbers.

2. Select a range of data. Pressing Ctrl+A inside a range of data selects the data range.

3. Select an entire worksheet. Pressing Ctrl+A outside a range of data selects the entire worksheet.

4. Select a column. Pressing Ctrl+Spacebar selects the entire column where your cursor is located.

5. Select a row. Pressing Shift+Spacebar selects the entire row where your cursor is located.

6. Go to cell A1. Pressing Ctrl+Home moves the cursor to cell A1 (unless you have your Transition navigation keys turned on, in which case pressing the Home key accomplishes this task).

7. Go to the end. Pressing Ctrl+End moves your cursor to the bottom-right corner of the active range. (The active range can be defined as that range from cell A1 to the intersection of the bottommost row and rightmost column in which you have entered data, even if you have since deleted that data.)

8. Hide a column. Pressing Ctrl+0 (zero) hides the current column, or columns if you have more than one column selected. This shortcut even works when you use the Ctrl key to select multiple columns that are not adjacent to one another.

9. Insert the date. Pressing Ctrl+Semicolon inserts the current date.

10. Insert the time. Pressing Ctrl+Shift+Semicolon inserts the current time.

J. Carlton Collins ( carlton@asaresearch.com ) is a technology consultant, CPE instructor, and a JofA contributing editor.

Submit a question
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Tips for first-year auditors

For a new auditor, the first busy season can be an exciting time and a fantastic opportunity for professional growth. Here are suggestions for new auditors and those who nurture their development.