Share via

Save time with Excel shortcuts

  • Article

If you've spent any time with Excel, you probably know that the Enter key advances you to the next cell in a column, and the arrow keys move your focus to the next cell in any direction. Here are some lesser known shortcuts you may want to add to your repertoire:

Fill down: Ctrl+D

Fill right: Ctrl+R

Create chart in new tab from selected cells: F11

Insert today's date: Ctrl+semicolon

Insert current time: Ctrl+colon

Enter hyperlink: Ctrl+K

Access Name Manager: Ctrl+F3

Add blank cells: Ctrl+plus

Delete cells: Ctrl+hyphen

Also, if you have a value that you want entered into a number of cells, select all of your target cells, type it, and then use Ctrl+Enter to fill all of them.

Suzanne

Comments

  • Anonymous
    November 23, 2011
    The comment has been removed

  • Anonymous
    March 06, 2012
    In addition to this great tip we have a FULL list of every shortcut...etc available here www.thecodecage.com/.../excel-keyboard-shortcuts

  • Anonymous
    April 17, 2012
    Pressing 'End' then any of the arrow keys will move you to the last filled/empty space in that direction. Holding 'Shift', pressing 'End' then the arrow will select all cells in that direction until the last filled/empty cell. CTRL+'Page Up/Down' moves to the next tab Holding Shift while CTRL+PgUp will select multiple tabs When multiple tabs are selected you can edit vales and formats across all tabs at the same time... be careful as you could delete data without realising! Values can be 'summed' between sheets.  Example, if you have 1 sheet per month (calles Jan, Feb, Mar...Dec), with the total sales figure for that month in Cell E25 then you can get the Yearly Sales by using the formula =SUM(Jan:Dec!E25) Enjoy :)

  • Anonymous
    June 12, 2012
    I am taking stats classes along with budgeting and discovering these shortcuts is like finding a small gold mine.  Thank you Thank you