Home » Blogs » Nick's blog

64. Excel Tips - Select Current Region - CTRL + A

Nick's picture
Submitted by Nick on 27 March, 2009 - 11:05


This tip is on how to select the Current Region using a keyboard shortcut:

CTRL + A

Suppose you have the following data:

Select-Current-Region

Pressing CTRL + A will select a square around all the cells that are connected to the current cell.

Select-Current-Region

If you are the left-most cell, press CTRL + A, then SHIFT + TAB, it will take you to the last cell.

 

Download sheet to practise how to Select Current Region in Excel

 

Video training on how to select the current region:

AttachmentSize
Select-Current-Region.xls17.5 KB
»