( New Chart ) This key is used to insert a new chart of current range/selected range in a separate sheet. (Activate Menu ) This key activates the menu form of the key with alphanumeric which you can select alphabet or number for access to the menu or commands without using the Mouse. (Calculates All ) Calculates the all open worksheets in all open workbooks it is very useful if you have selected manual calculation in the Excel options.

(Extend Selection ) This will block the cell that is selected and give you the option to expand your selection using the arrow keys. (Spell Check) This will give you the Spelling dialog to check the spelling and correct them to be new or corrected. (Next Pane) It is used to select/switching the pan and ribbon area. (Goto ) It opens a GOTO dialog box from you can reach the cell reference. (Paste Name/Formula) When you click this key, it opens a dialog box(paste name), which shows the named range in your data that you previously set and if you select the naming range from the dialog box on the OK button, It pastes the data but only if when the cell is located in the naming range. (Edit Mode )This key opens the cell in edit mode which you can add, delete, or fix your data in the cell. (Help) This shortcut key opens an EXCEL HELP where you can search your query about MS Excel and gain all knowledge of MS Excel. As shown below image.ĬTRL+U: (Underline) This shortcut Key used to apply Or Remove Underline in the Data whichever text or numbers.ĬTRL+V: (Past) Used to paste a copied Item whichever it is text, Number, data, image, chart etc.ĬTRL+W: (Open the Close Menu) this shortcut Key open the close menu that you save your data and close your file.ĬTRL+X: (Cut) This shortcut key is used to cut the selected item that we can move to the next location it like CTRL+D Shortcut key but it unlike the it moves to Right side.ĬTRL+S: (Save File) This shortcut key is used to save the current file.ĬTRL+T: (Create Table) This shortcut key is used to create or insert tables in your data that converts your data as Tabular Form.

CTRL+R: (Fill to the Right) This shortcut key is used to fill the data or copy the data into the Right side cell, but it only copies the first cell data.

Ms excel shortcut keys pdf