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.
I use this option quite often. The kind of data I see in a day o day basis contains various tables in a single worksheet. So, I need to select the current region rather than complete worksheet. Specially, I use this to either to filter the data or sort the data.
It will be interesting to see your comments and experiences on using this option.
Define Current Array
As per Microsoft an array is used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.
If your active cell is in an array and you want to select whole array then it is easy to select whole of the array.
Keyboard Shortcut: Press F5, then Alt+S+A
To be honest, I have known this option in Excel but was never able to use this. That is may be because I do not operate in area of arrays. Never mind. It’s the time for you guys to tell how often you use this option and in what scenarios.
Share your experience:
Do you use this option more often? Share your experiences, how do you deal with this type of data. Have another tip do this stuff? Also, do not forget to leave your comments on this post. I learn a lot from you all.
I’ll be posting soon, fifth post of this series “Go to Special – Select Objects”. Past few months, I have been using this day in and day out. Thanks to Excel (Microsoft).
Links to other posts of this series:
Go To Special Series. Select CommentsGo To Special Series. Select Constants and FormulasGo To Special Series. Select Blanks
No comments:
Post a Comment