Posted on

MS Excel Selection Shortcuts

Spread the love

MS Excel Shortcuts

Selection

Select entire row

To select all the cells in a specific row you can use the command Shift + Spacebar.

Select entire column

To select a particular column, use the command Ctrl + Spacebar.

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

To select cells to the right of the current cell you can use the Shift + right arrow key commands. This will select the cell immediately to the right of the current cell.

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

To select a cell that is directly above the current cell, use the command Shift + up arrow.

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

To select a single character to the left of the current character use the command Shift + left arrow key.Select one word to the right

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.

Leave a Reply