13 handy Excel data entry shortcuts (free PDF)

This list of Excel keyboard shortcuts will help you enter data, create names, and complete functions more easily and efficiently.

Bonus tip:

Quickly return to the active cell
Some spreadsheets are large and extend well past the right and lower edges of your screen. There are many ways to navigate a large spreadsheet, but scrolling right or down and losing sight of the active cell is quite common. A simple scroll up or left will return you to where you were—to the active cell—in a small spreadsheet. Getting back to the active cell might prove more difficult in a large sheet. Of course, you probably remember the general direction of the active cell, but depending on just how far you’ve wandered, scrolling back to the active cell is probably the least efficient way to get there.

Now, if you remember the active cell, you can press Ctrl + G and enter the cell address or range name and click OK. But if you don’t remember the cell reference, this keyboard shortcut will save you a lot of scrolling: When you’ve lost sight of the active cell, just press Ctrl + Backspace. Excel will return you to the active cell from anywhere in the same sheet.

Resource Details

TechRepublic logo
Provided by: