Excel Short Cuts

el

http://www.bettersolutions.com/excel.aspx

| End + Home | Moves to the last used cell on the active worksheet* |

F11 | Creates a chart (on a chart sheet) using the highlighted range |

Shift + F9 | Calculates just the active worksheet |

Ctrl + 1 | Displays the (Format > Cells) dialog box |

Ctrl + D | Copies the first cell in the selection downwards (Edit > Fill > Down) |

Ctrl + Page Down | Moves to the next worksheet in the active workbook |

Ctrl + Tab | Moves to the next workbook or window |

Ctrl + Shift + Down Arrow | Selects all the cells to the end of the current region |

Alt + Shift + F1 | Inserts a new worksheet into the active workbook |

Alt + Down Arrow | Displays the Pick From List drop-down list |

Ctrl + Shift + = | Inserts rows above the current selection or displays the (Home > Insert > Insert Cells) dialog box |

Ctrl + - | Deletes the rows currently selected or displays the (Home > Delete > Delete Cells) dialog box |

|   |

  | Note: *This is only updated when the workbook is closed. |

  | |

  | Leading the way in Microsoft Office Development |

  | Home | | | Excel | | | Word | | | PowerPoint | | | VBA | | | SharePoint | | | Consultancy | | | Newsletter | | | Contact |   |

  | Excel > Shortcut Keys > Shortcuts | < Previous | Next > |   |

  | Function Keys |   |

  | F1 | Displays the Help task pane or (Help > Microsoft Excel Help) |

F2 | Edits the active cell, putting the cursor at the end* |

F3 | Displays the (Insert > Name > Paste) dialog box |

F4 | Repeats the last worksheet action (Edit > Repeat) |

F5 | Displays the (Edit > GoTo) dialog box |

F6 | Moves to the next pane in a workbook (if the window is split) |

F7 | Displays the (Tools > Spelling) dialog box |

F8 | Toggles whether to extend a selection with the arrow keys |

F9 | Calculates All the worksheets in All the open workbooks |

F10 | Toggles the activation of the...