Useful Shortcut Keys for Ms - Excel

Useful Shortcut Keys for Ms - Excel

BACKSPACE ::--

• Deletes one character to the left in the Formula Bar.   
• Also clears the content of the active cell.

DELETE  ::--

• Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.   
• In cell editing mode, it deletes the character to the right of the insertion point.

END  ::--

• Moves to the cell in the lower right corner of the window when SCROLL LOCK is turned on.   Also selects the last command on the menu when a menu or sub menu is visible.   
• CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.   
• CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower- right corner).

ENTER :: --

• Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). 
• In a data form, it moves to the first field in the next record.   
• Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.   
• In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).   
• ALT+ENTER starts a new line in the same cell.   
• CTRL+ENTER fills the selected cell range with the current entry.   
• SHIFT+ENTER completes a cell entry and selects the cell above.

ESC  :: --

• Cancels an entry in the cell or Formula Bar.   
• It also closes an open menu or submenu, dialog box, or message window

HOME  :: --

• Moves to the beginning of a row in a worksheet.   
• Moves to the cell in the upper- left corner of the window when SCROLL LOCK is turned on.   
• Selects the first command on the menu when a menu or sub menu is visible.   
• CTRL+HOME moves to the beginning of a worksheet.   
• CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.

PAGE DOWN  :: --

• Moves one screen down in a worksheet.   
• ALT+PAGE DOWN moves one screen to the right in a worksheet.   
• CTRL+PAGE DOWN moves to the next sheet in a workbook.   
• CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.

PAGE UP  :: --

• Moves one screen up in a worksheet.   
• ALT+PAGE UP moves one screen to the left in a worksheet.   
• CTRL+PAGE UP moves to the previous sheet in a workbook.   
• CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.

SPACE BAR  :: --

• In a dialog box, performs the action for the selected button, or selects or clears a check box.   
• CTRL+SPACE BAR selects an entire column in a worksheet.   
• SHIFT+SPACE BAR selects an entire row in a worksheet.   
• CTRL+SHIFT+SPACE BAR selects the entire worksheet.   
• If the worksheet contains data, CTRL+SHIFT+SPACE BAR selects the current region. 
• Pressing CTRL+SHIFT+SPACE BAR a second time selects the entire worksheet. 
• When an object is selected, CTRL+SHIFT+SPACE BAR selects all objects on a worksheet.   
• ALT+SPACE BAR displays the Control menu for the Excel window.

TAB  :: --

• Moves one cell to the right in a worksheet.   
• Moves between unlocked cells in a protected worksheet.   
• Moves to the next option or option group in a dialog box.   
• SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.  
• CTRL+TAB switches to the next tab in dialog box.  
• CTRL+SHIFT+TAB switches to the previous tab in a dialog box.