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
Search By Tags

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


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


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

2020 | Copyright | Summit Solutions