Loading...

Welcome to StudyVen

Ctrl+Shift+Tab : Switches to the previous tab in a dialog, or (if no dialog is open) switches between all Excel windows.
Shift+Tab : Moves to the previous cell in a worksheet or the previous option in a dialog.
Ctrl+Tab : Switches to the next tab in a dialog, or (if no dialog is open) switches between 2 Excel windows. 
Tab key : Moves between unlocked cells in a protected worksheet.
Tab key : Moves to the next option or option group in a dialog.
Alt+Spacebar : Displays the Control menu for the Excel window.
Tab key : Moves one cell to the right in a worksheet.
Ctrl+Shift+Spacebar : If the worksheet contains data, __________________ selects the current region. Pressing __________________ a second time selects the current region and its summary rows. Pressing __________________ a third time selects the entire worksheet.
Ctrl+Shift+Spacebar : When an object is selected, __________________ selects all objects on a worksheet.
Shift+Spacebar : Selects an entire row in a worksheet.
Ctrl+Shift+Spacebar : Selects the entire worksheet.
Spacebar : In a dialog, performs the action for the selected button, or selects or clears a check box.
Ctrl+Spacebar : Selects an entire column in a worksheet.
Shift : Hold the Shift key while you drag a selected row, column, or selected cells to move the selected cells and drop to insert them in a new location.
Ctrl+Page Up : Moves to the previous sheet in a workbook.
Ctrl+Shift+Page Up : Selects the current and previous 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 Down : Moves to the next sheet in a workbook.
Ctrl+Shift+Page Down : Selects the current and next sheet in a workbook.
Page Down : Moves one screen down in a worksheet.
Alt+Page Down : Moves one screen to the right in a worksheet.
Ctrl+Home : Moves to the beginning of a worksheet.
Ctrl+Shift+Home : Extends the selection of cells to the beginning of the worksheet.
Home : Moves to the cell in the upper-left corner of the window when Scroll Lock is turned on.
Home : Selects the first command on the menu when a menu or submenu is visible.
Escape key : It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.
Home : Moves to the beginning of a row in a worksheet.
Escape key : Cancels an entry in the cell or Formula Bar.
Escape key : Closes an open menu or submenu, dialog, or message window.