May 31, 2011

Discovering shorcut Excel 2010

F11 => Create a new chart on a separate chart sheet (of the default chart type) by using data in the selected range.

Alt+F1 => Create a new, embedded chart (of the default chart type) by using the data in the selected range.

F5 => Display the Go To dialog box.


Alt => Display the keytips for the Ribbon commands so that you can access the commands by using letters on the keyboard.
 
F2 => Edit the active cell.
 
Shift+F2 => Edit the comment in the active cell or insert a comment if the cell doesn’t have one.
 
Ctrl+Shift+_ => Remove all borders from the selected cells.
 
Shift+F10 => Display the shortcut menu for the selected item.
 
Ctrl+F6 => Activate the next window.
 
Ctrl+PgUp => Activate the previous sheet in the workbook.
 
Ctrl+PgDn => Activate the next sheet in the workbook.
 
Alt+Ctrl+V => Display the Paste Special dialog box.
 
Alt+= => Perform the equivalent of clicking the AutoSum button.
 
Ctrl+B => Make the selected cells bold.
 
Ctrl+C => Copy the selected cells.
 
Ctrl+D => Copy the top cell in a selected range to the other cells in the selection.
 
Ctrl+F => Display the Find dialog box.
 
Ctrl+H => Display the Replace dialog box.
 
Ctrl+I => Make the selected cells italic.
 
Ctrl+N => Create a new default workbook.
 
Ctrl+R => Copy the leftmost cell in a selected range to the other cells in the selection.
 
Ctrl+S => Save the active workbook.
 
Ctrl+V => Paste a copied or cut item in the selected cell.
 
Ctrl+X => Cut the selected cells.
 
Ctrl+Y => Repeat the last repeatable command. If the last command was Undo, this shortcut reverses the Undo.
 
Ctrl+Z => Undo the last action.

0 comments:

Post a Comment

Top