CTRL+3– Removes or Applies Italic format.

CTRL+2– Removes or Applies Bold format.

CTRL+1– Displays the Format dialog box.

ALT+F11 – Open the Microsoft Visual Basic Editor, in which you can create a macro by using VBA (VB for Applications).

F11– Create chart of the data in the current range.

CTRL+F10– Maximizes or restores the selected workbook window.

ALT+SHIFT+F10– Displays the menu or message for a smart tag.

SHIFT+F10– Display the shortcut menu for a selected item.CTRL+F9– Minimizes a workbook window to an icon.CTRL+ALT+SHIFT+F9– Recheck the dependent formula and then calculate all the workbook.CTRL+ALT+F9 – Calculates all the worksheets, regardless of whether they have changed since the last calculation.F9– Calculates all worksheets in all open workbook.

ALT+F8– Displays Macros dialog box to create run, edit or delete a macro.

CTRL+F8– Performs size command when the workbook is not maximized.SHIFT+F8 – Enables you to add a nonadjacent cell.F6– Switches between Worksheet, Shortcut icons, task pane and Zoom Controls.CTRL+F5– Restores the window size of the selected workbook window.CTRL+F4– Close the selected workbook window.F4 – Repeat the last command or action.SHIFT+F3– Display the insert Function Dialog box.F3 – Display the Paste name Dialog box.

CTRL+F2 – Display the Print Preview window.SHIFT+F2 – adds or edit a cell comment.F2– Edit the active cells and also moves the insertion point into the formula bar.ALT+F1 – Creates a chart of the data in the current range.CTRL+F1– Displays or Hides the shortcut menu or icons.MS Excel 2007 Shortcut Keys Padma Pendyala

Excel shortcut keys 2007