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


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.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions