Keyboard Shortcut for resizing an array

D

Daniel

Hi,

I'm sure I saw on the web a keyboard short for changing the size of an
array but have had no luck finding it again. (It was paired with Ctrl +
/ selection of an array.) Does such a shortcut exist? I know I could
write a simple macro, but would lose the undo buffer.

Many thanks,

Daniel
 
P

Pete_UK

Do you mean you already have a range highlighted and you want to extend
it or make it smaller? If so, then hold down the <shift> key and use
the arrow keys to extend or reduce the highlighted range. Release the
<shift> key when you have done.

Hope this helps.

Pete
 
D

Daniel

Hi Pete,

Thanks for the speedy response. I actually meant an excel array
formula. A snippet from the help:

array formula: A formula that performs multiple calculations on one or
more sets of values, and then returns either a single result or
multiple results. Array formulas are enclosed between braces { } and
are entered by pressing CTRL+SHIFT+ENTER.), Microsoft Excel
automatically inserts the formula between { } (braces).
End snippet
Click to expand...

Once created the array can be expanded in size by selecting a range
larger than the array formula then pressing {F2} to edit the formula
and Ctrl+Shift+Enter. However this method does not allow making the
array formula.

I work with array formulas a great deal so finding the shortcut key
would be a great timesaver.

Thanks again,

Daniel
 
D

Daniel

argh! sorry the one but last sentence should read - However this method
does not allow making the array formula SMALLER.
 
H

Herbert Seidenberg

Select the array or, if one of its cells is selected, press
CTRL+/ to select the whole array.
Click on the formula bar and press
CTRL+ENTER
Move the fill handle to decrease or increase the range and
CTRL+SHIFT+ENTER
 
H

Herbert Seidenberg

Peo,
Your suggestions and comments are always welcome.
I learned a lot from you.
Herb
 
D

Daniel

Hi,

Using Ctr+Enter does indeed work and will save me time. I'm sure I saw
a single shortcut to do all of this but I must be mistaken.

Thanks again,

Daniel
 
Top