Cntrl+/ What Does It Do?

[Cyberdude]

When I want to type a question mark ("?") I have a habit of accidentally pressing the Ctrl key instead of the Shift key before pressing the "?" key (which is also the "/" key). The result is that I press "Ctrl+/", and Excel responds with the message: "No cells were found". My questions is, what does "Ctrl+/" do?

[Norie]

From help.

CTRL+/ Select the current array, which is the  array that the active cell belongs to

Though I've no idea how this works because I get the No cells found message whatever I select.

[Ken Puls]

Hi guys,

Example workbook attached. Put your cursor in one of the yellow cells and press CTRL + /

HTH

[Cyberdude]

Ken, I hate to be dense about this, but I tried it, and nothing seemed to happen, except it seemed to select the array in column "A". None of the values changed ... BUT I didn't get the message!
I gotta say that I have a hunch that this is a tool I won't be using often.

[Ken Puls]

Exactly, Sid. That's the point.

When you have one cell in the middle of the array, it will select the entire array, not just the one cell. Personally, I never use arrays like what I uploaded, as there is no need to build one like that. I did inherit one though, and in order to break it, you have to select the entire array. This function could be handy there, I suppose.

Can't say it's a keyboard combo that I keep sharpened in my toolbox though.

[Bob Phillips]

When you have one cell in the middle of the array, it will select the entire array, not just the one cell. Personally, I never use arrays like what I uploaded, as there is no need to build one like that. I did inherit one though, and in order to break it, you have to select the entire array. This function could be handy there, I suppose.

Even if you do use this type of block-array formula as I do, you do not need this keyboard combo. Just select any cell within the range, and update it within the formula bar (CSE), and the whole range gets selected.

[Zack Barresse]

Just as a note, this type of array is different than the other types of arrays associated with the worksheet. It's an array of cells, not an array formula.