After Hours

10+ keyboard shortcuts for speeding your work with Excel data


Shortcuts can save you a considerable amount of time when you're entering or modifying data in a worksheet -- but only if you can remember them. This list offers a quick reminder of some old standbys, along with a few shortcuts that are less well known but equally useful.

A comprehensive list of Excel shortcuts is available as a PDF download.

Action Shortcut
Complete an entry and move to the next cell Enter
Insert a new line within a cell Alt+Enter
Enable editing within a cell F2
Fill selected cells with an entry you typed in one cell Ctrl+Enter
Cancel an entry Esc
Fill data down through selected cells Ctrl+D
Fill data through selected cells to the right Ctrl+R
Create a name Ctrl+F3
Insert a hyperlink Ctrl+K
Insert the current date Ctrl and ; (semicolon)
Insert the current time Ctrl and : (colon)
Delete from the insertion point to the end of the line Ctrl+Delete
Add blank cells Ctrl and Shift+ (plus)
Delete selected cells Ctrl and - (hyphen)
Create a chart from a range of data F11

About

Jody Gilbert has been writing and editing technical articles for the past 25 years. She was part of the team that launched TechRepublic and is now senior editor for Tech Pro Research.

3 comments
vjanecky
vjanecky

click in the address bar and press F4 to toggle between absolute and relative reference.

MJGunther
MJGunther

Nice collection of keyboard shortcuts, but the first one (input and move to next cell) has two shortcuts, depending on the direction of input: Type + Enter takes you to the next cell DOWN; Type + Tab takes you to the next cell RIGHT. When inputting across, using TAB to move from cell to cell, pressing ENTER brings you to the cell in the next row beneath the first cell input in the row above.

Editor's Picks