MS Excel Tip: Keyboard shortcuts - selecting an entire range


To select / highlight an entire range without having to drag your mouse from top left to bottom right, simply select a single cell within the range and use the keyboard shortcut ctrl + A (All).

With the ctrl key still depressed, pressing A a second time will highlight the entire sheet. Simple but very effective, especially if you have a large range to highlight.

NB! This will only work if the data that you’re selecting does not have any empty rows or columns. This will in effect split your data into separate ranges or regions - one of the many reasons why you should not have empty rows and columns in your data.

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