Search Contextures Sites

Excel Keyboard Shortcuts

Navigate cells

  • Right .......... Tab
  • Start of worksheet .......... Ctrl + Home
  • End of worksheet  .......... Ctrl + End
  • Start of row .......... Home
  • Up/ down screen ... Page Up/ Down

Standard actions

  • Activate menus ........ F10
  • Save .......... Ctrl + S
  • Print .......... Ctrl + P
  • New workbook .......... Ctrl +
  • Open .......... Ctrl + O
  • Copy .......... Ctrl + C
  • Cut .......... Ctrl + X
  • Paste .......... Enter

Copy data

  • Fill down .......... Ctrl + D
  • Fill right .......... Ctrl + R
  • Copy formula above .......... Ctrl + '
  • Copy value above .......... Ctrl + "

Format Numbers

  • General .......... Ctrl + Shift + ~
  • Currency .......... Ctrl + Shift + $
  • Percentage .......... Ctrl + Shift + %
  • Date (d, m, y) .......... Ctrl + Shift + #
 

Select

  • Entire Column .......... Ctrl + space
  • Entire Row .......... Shift + space
  • Entire worksheet .......... Ctrl + A

Work in a range

  • Select the current range .......... Ctrl + *
  • Move to range border ....... Ctrl + arrow
  • Move down .......... Enter
  • Move up .......... Shift + Enter
  • Move right .......... Tab
  • Move left .......... Shift + Tab
  • Switch focus to the worksheet from
       range selector in dialog box....F6

Edit worksheet

  • Edit a cell .......... F2
  • Insert .......... Ctrl + +
  • Delete .......... Ctrl + -

Complete actions

  • Repeat last action .......... F4
  • Today’s date .......... Ctrl + ;
  • Chart selected data .......... F11

Apply Formatting

  • Format cells .......... Ctrl + 1
  • Remove borders .......... Ctrl + Shift + _

Return to Tips page -- www.contextures.com/tiptech.html --
(download Excel keyboard shortcuts pdf file) (download Excel keyboard shortcuts zipped Excel file)

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright © 2009.
All rights reserved.

 



Debra Dalgleish