MS Excel Shortcuts
Select entire row
To select all the cells in a specific row you can use the command Shift + Spacebar.
Select entire column
Select entire worksheet
To select all the cells in a worksheet, use the Ctrl + A command.
Add adjacent cells
You can add cells adjacent to an existing selection by holding down the Shift key and clicking on them.
Extend selection one cell to the right
Extend selection by one cell to the left
Just as you can select a cell to the right you can also select one to the left of your current cell. The command Shift + left arrow will allow you to select a cell to the left of the cell you are currently on.
Extend by one cell up
Extend by one cell down
Similarly, use the command Shift + down arrow to select a cell below the current cell.
Extend to the last cell on the right
Ctrl + Shift + right arrow is used to select the last cell to the right of the current cell.
Extend to the last cell on the left
To select the cell on the extreme left of the current cell, use the command Ctrl + Shift + left arrow.
Extend to the last cell up
Similarly, Ctrl + Shift + up arrow can be used to select up to the last cell on the top.
Extend to the last cell down
Ctrl + Shift + down arrow will allow you to select all the cells till the last cell below the current cell.
Extend selection to start of row
Shift + Home is the command used to extend the selection up to the beginning of a particular row.
Extend selection to first cell
To extend the selection from the current cell to the very first cell, use the command Ctrl + Shift + Home.
Extend selection to last cell
Ctrl + Shift + End is the command used to select cells up to the very last cell of the worksheet.
Select cells with comments
To select specific cells, such as those that have comments, use the command Ctrl + Shift + O. Only the cells that have comments attached to them will get highlighted.
Select one character right
Shift + right arrow is used to select a single character to the right of the current character.
Select one character left
Use Ctrl + Shift + right arrow to select a word to the right of the present word.
Select one word to the left
Use Ctrl + Shift + left arrow to select a word to the left of the present word.