Administrative Professional Today

The administrative professional’s guide to accelerated career development. Administrative Professional Today offers practical advice on office efficiency, politics, communication skills, time management, supervisory problems and technology. The monthly issues and weekly electronic forum give special attention to the changing duties of administrative professionals in today’s business environment. Learn more about Administrative Professional Today and the two free reports you’ll get when you subscribe...

Have you discovered all the shortcuts buried within Excel?

Try zipping around Excel spreadsheets using these keyboard techniques:

• “Home” changes the “active cell” to the cell in column A of the current row.
• “Ctrl”+“Home” makes cell A1 the active cell.
• “Ctrl”+“End” changes the active cell to the cell farthest down and to the right of all the cells.
• The right, left, up and down arrow keys advance your work sheet and your active cell one cell at a time.
• “Page Up” and “Page Down” advance the work sheet and the active cell up and down, respectively, one screen at a time.
• “Alt”+“Page Up” and “Alt”+ “Page Down” advance the work sheet and the active cell left and right, respectively, one screen at a time.
• “Ctrl”+“Page Up” and “Ctrl”+ “Page Down” change the view to the next sheet and previous sheet, respectively.
• “Ctrl”+arrow key (or “End” key followed by an arrow key) moves the cellpointer in the direction of the arrow pressed. The cellpointer goes to the first occupied cell if you start from a blank cell, or it goes to the last occupied cell if you start in an area where the cells are occupied.

—Adapted from "Excel Tip: Moving Around the Worksheet," www.accountingweb.com