P
PAL
Sometimes I get an error message, "You can't change part of an array". Two
cells apparently get linked. How do I get out of this.
cells apparently get linked. How do I get out of this.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
D
David Biddulph
Select all the cells which are using the array formula, before entering the
formula with control shift enter.
formula with control shift enter.
P
PAL
Formula is already there. Do I have to redo formula?
D
David Biddulph
You said you were trying to change the formula.
H
Harlan Grove
PAL said:Sometimes I get an error message, "You can't change part of an array". Two
cells apparently get linked. How do I get out of this.
If you want to 'unlink' the cells, meaning each of these cells'
formulas would become regular formulas, hold down a [Ctrl] and a
[Shift] key and double click on the cell with the problem formula to
select all the cells in the array, press [F2] to edit the formula,
then hold down a [Ctrl] key and press [Enter]. The formulas in all the
selected cells will now be separate, regular formulas, but it's
possible they may all return #VALUE!. That depends on what the
formulas are.