Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 918
  • Last Modified:

Excel "un"-Array formula in range of cells

How can I "un'-Array a formula in a range of cells?

Currently, I have a range of cells containing an array formula, and I want to make it a plain formula for all the cells.  Is there a way to highlight the range and then "un"-Array the formula in all the cells?  Everything I try gives me error message: "You cannot change part of an array".

Thanks, --Andres
0
AndresHernando
Asked:
AndresHernando
1 Solution
 
Rory ArchibaldCommented:
That would imply that you are not changing all the cells. When you have selected all of them, and edited the formula, you need to use Ctrl+Enter rather than just Enter to commit the change.
0
 
leptonkaCommented:
Hi,

Here are some methods how can you highlight cells where there are array formulas.
The simplest is Ctrl-G (or F5) Special..>Current array>ok

You need to select the whole array and delete it. After it you can write your plain formula.

http://www.linkedin.com/groups/Where-are-my-array-formulas-3843467.S.98906603

Cheers,
Kris
0
 
AndresHernandoAuthor Commented:
Thanks Rory, that's exactly what I needed.
Kris, I couldn't make it work your way, but thanks for replying to my post.
Thanks again, --Andres
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now