Undo a array

  • Thread starter Scott Calkins via OfficeKB.com
  • Start date
S

Scott Calkins via OfficeKB.com

OK I did a big stuped. I was trying to save a bit of time in going to each
cell and converting it to a array by using thr ctrl-shift-enter. Not
thinking I decided to save some time and highlight a section of cells then
use the ctrl-shift-enter. After figuring out my blunder I went in to
change the cells back to the correct formula, but get the "cannot change a
array" error. How do I turn off the array on these blocks of cells?
 
B

Biff

Hi!

Here's one way.

Select the range of array formulas.

In the formula bar precede the formula with an apostrophe to convert the
formula to text. Hit CTRL ENTER.

That will "break" the array but now you have to remove the apostrophe from
each individual formula to convert them back to formulas.

Biff
 
H

Harlan Grove

Biff said:
Here's one way.

Select the range of array formulas.

In the formula bar precede the formula with an apostrophe to convert the
formula to text. Hit CTRL ENTER.

That will "break" the array but now you have to remove the apostrophe from
each individual formula to convert them back to formulas.
Click to expand...
....

There's a slightly quicker way. If the entire array has been selected, press
[F2] and [Ctrl]+[Enter] in sequence. All the cells should now be separately
entered as nonarrays. Unfortunately, all the original formulas are lost
aside from the cell in which the array entry was first made.
 
Top