Keyboard Shortcut for resizing an array

  • Thread starter Thread starter Daniel
  • Start date Start date
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
 
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
 
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
 
argh! sorry the one but last sentence should read - However this method
does not allow making the array formula SMALLER.
 
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
 
You don't even have to click in the formula bar, YOU CAN USE f2 AS WELL
 
Peo,
Your suggestions and comments are always welcome.
I learned a lot from you.
Herb
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arrays containing variable sheets 2
Shortcuts on french keyboard 2
Menu shortcuts assigned certain keyboard 2
Chrome keyboard shortcuts 2
How to add keyboard shortcut to macro un add-in ? 3
Pasting an object into a cell with a drop down menu 1
Assign a keyboard shortcut to the Start menu? 2
Keyboard Shortcuts - Ctrl+Shift+Down Arrow 3

Back
Top