Excel > Excel 2007 Foundation > Getting Started

Excel 2007 keyboard shortcuts

Shortcuts are the quickest way of getting tasks done in Excel. In Excel 2007 it is even more beneficial to have some worthwhile keyboard shortcuts under your belt to save time.

Download the keyboard shortcuts reference sheet

Standard

Ctrl + N – New Workbook

Ctrl + O – Open

Ctrl + W – Close Window

Alt + F4 – Quit Excel

Ctrl + S – Save

Ctrl + P – Print

Ctrl + Z – Undo

Ctrl + Y – Redo

Ctrl + K – Hyperlink

Ctrl + ‘ – Copy Cell Above

Ctrl + ; - Insert Today's Date

Ctrl + + - Insert Row or Column

Shift + F11 – New Worksheet

F1 – Help

F2 – Edit Mode

F5 – Go To

F7 – Spell Check

Alt + F11 – VB Editor

Selection and Navigation

Ctrl + F – Find

Ctrl + G – Go To

Ctrl + H – Replace

Ctrl + Arrow - End of Row or Column

Ctrl + Home – Start of Worksheet

Ctrl + End – End of Worksheet

Ctrl + Page Up – Previous Worksheet

Ctrl + Page Down – Next Worksheet

Ctrl + Tab – Move to Next Open Workbook

Ctrl + A - Select All

Ctrl + Shift + Arrow - Select Range to End of Row or Column

Ctrl + Shift + Home – Select Range to Start of Worksheet

Ctrl + Shift + End – Select Range to End of Worksheet

Ctrl + Spacebar – Select Column

Shift + Spacebar – Select Row

 

Formatting

Ctrl + B – Bold

Ctrl + I – Italic

Ctrl + U – Underline

Ctrl + 1 – Format Cells

 

Moving and Copying

Ctrl + X – Cut

Ctrl + C – Copy

Ctrl + V – Paste

Click and Drag – Move

Ctrl + Click and Drag - Copy

Follow us on

Facebook  Twitter  You Tube