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.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment