Loading...

Welcome to StudyVen

Select the current region around the active cell. : Ctrl+Shift+Asterisk (*)
Select the first command on the menu when a menu or submenu is visible. : Home
Extend the selection of cells to the beginning of the worksheet. : Ctrl+Shift+Home
Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheet. : Ctrl+A or Ctrl+Shift+Spacebar
Select an entire row in a worksheet. : Shift+Spacebar
Select all objects on a worksheet when an object is selected. : Ctrl+Shift+Spacebar
Complete a cell entry and select the cell above. : Shift+Enter
Select an entire column in a worksheet. : Ctrl+Spacebar
Start a new line in the same cell. : Alt+Enter
Fill the selected cell range with the current entry. : Ctrl+Enter
Turn extend mode on and use the arrow keys to extend a selection. Press again to turn off. : F8
Add a non-adjacent cell or range to a selection of cells by using the arrow keys. : Shift+F8
Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. : Ctrl+Shift+Arrow key
Select the current and previous sheet in a workbook. : Ctrl+Shift+Page Up
Extend the selection of cells by one cell. : Shift+Arrow key
Select the entire worksheet. : Ctrl+A or Ctrl+Shift+Spacebar
Select the current and next sheet in a workbook. : Ctrl+Shift+Page Down
Paste only formulas and number formats from copied cells. : R
Paste only the values (not formulas) and number formats from copied cells. : U
Paste all cell contents without borders. : X
Paste only column widths from copied cells. : W
Paste only the data validation settings from copied cells. : N
Paste all cell contents and formatting from copied cells. : H
Paste only the copied formatting. : T
Paste only comments and notes attached to the cell. : C
Paste only the formulas as entered in the formula bar. : F
Paste only the values (not the formulas). : V
In Excel 2013, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the : Paste Special dialog.
Paste all cell contents and formatting. : A
Display the Create Table dialog. : Ctrl+L or Ctrl+T