Showing posts with label select current array. Show all posts
Showing posts with label select current array. Show all posts

Saturday, October 16, 2010

Go To Special Series. Select Current Region and Current Array

Go To Special series. Select Current Region and Current Array

Happy "Dusserah" to all the readers. This Dusserah, may you be blessed with good fortune, Wealth and prosperity, Happiness. Wish you and your family a fun filled Dusserah!

Welcome to the fourth post of this series – Select current region and current array. Click here to read to navigate to go to special.

Define Current Region
The range of cells filled in with data and including the current selected cell or cells. The region extends in all directions to the first empty row or column. Selecting a current region is selecting an entire list of data.

Keyboard Shortcut: Press F5, then Alt+S+R or simply Ctrl+A or SHIFT + CTRL + SPACE bar