The most used Excel shortcuts are:
- CTRL+1 Displays the Format Cells dialog box.
- CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
- CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
- CTRL+T Displays the Create Table dialog box.
- F5 Displays the Go To dialog box.
---------------------------------------------------------------------------------
The most useful generic Windows shortcuts are:
- CTRL+A Selects the entire data.
- CTRL+C Copies the selected text/object/cells.
- CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
- CTRL+X Cuts the selected text/object/cells.
- CTRL+P Displays the Print dialog box.
- CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.
- CTRL+S Saves the active file with its current file name, location, and file format.
For more Excel shortcuts click here or look on the tool at the bottom of the blog.
No comments:
Post a Comment