Microsoft Excel Shortcuts
=======================
Ctrl + 1= Shows the format Cells Dialog box
Ctrl + 2= Applies or removes Bold formatting
Ctrl + 3= Applies or removes Italic formatting
Ctrl + 4= Applies or removes Underlining
Ctrl + 5= Applies or removes strikethrough.
Shift + Spacebar= Selects an entire row in a worksheet
Ctrl + Spacebar= Selects an entire column in a worksheet
Ctrl + Shift+ Spacebar= Selects an entire worksheet
Ctrl + Home= Moves to the beginning of a worksheet
Ctrl + End= Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text
Ctrl + F1= Displays or hides the ribbon
Ctrl + F4= Closes the selected workbook window
Page-Up= Moves one screen up in a worksheet
Page-Down= Moves one screen down in a worksheet
Ctrl + Enter= Fills the selected cell range with the current entry
Alt + Enter= Starts a new line in the same cell.
Shift + Enter= Completes a cell entry and selects the cell above
Arrow Right= Moves one cell right in a worksheet
Arrow-Left= Moves one cell left in a worksheet
Arrow-Up= Moves one cell up in a worksheet
Arrow-Down= Moves one cell down in a worksheet
Shift + Arrow Right= Extends the selection of the cells by cells (right)
Shift + Arrow left= Extends the selection of the cells by cells (left)
Shift + Arrow up= Extends the selection of the cells by cells (up)
Shift + Arrow down= Extends the selection of the cells by cells (down)
0 Comments