How to activate array formulas in a range of cells all at the same time?

  • Thread starter Thread starter Karenna
  • Start date Start date
K

Karenna

Is there a built in command or a macro that can do this? It's ver
tedious to type ctl shift enter for every cell in a large array.

Please let me know if there is any way to do this?

Thanks,
Karenn
 
What do you mean by that? You can enter a large array formula over several
cells in one fell swoop
or if the array formula is for one cell you can array enter it and copy the
usual way to other cells
 
Hi Karenna,
You do not do it for each cell one-by-one
Select the range of cells, enter the array formula, press SHIFT+CTRL+ENTER
 
There are different formulas in each cell; I suppose I'm asking i
there's a macro that will do this for a group of cells.

Thanks,
Karenn
 
Give us an example of the different formulas. I haven't come across any
situation where I would need to do what you are describing, so it's kind of hard
to visualise at the moment. Pick 4 or 5 contiguous cells that you are entering
manually and just copy and paste the formulas from each into the note so we can
see what you are referring to.
 
Back
Top