MS Excel Tip: Keyboard shortcuts - selecting a data row or column

August 16, 2018

In a nutshell – holding down the Shift Key anchors your current cell selection, the ctrl key moves to the end of a continuous range of data and the arrow keys give you direction.

 

Employing a combination of these keys enables one to quickly highlight a specific selection of data without using a mouse. Below are 2 common combinations that enable one to select a data row or column.

 

To select a row of Data: First navigate to the start of the row (ctrl + left arrow) to change the cell selection to the first column in the table and then press Ctr+Shift+right arrow to highlight the entire row. NB! As in the example the selection will stop at the first empty cell, to go beyond this keep re-pressing the right arrow.

 

To select a Column of Data: First navigate to the top of the column (ctrl + up arrow) to change the cell selection to the first row in the table and then press Ctr+Shift+down arrow to highlight the entire column. NB! As with rows the selection will stop at the first empty cell, to go beyond this keep re-pressing the down arrow.

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts

Excel Tip – Quickest way to move a column!

November 6, 2019

1/1
Please reload

Recent Posts