Overwriting cells

  • Thread starter StephenAccountant
  • Start date
S

StephenAccountant

Ok I have a formula in Cell A1 and a formula in Cell B1.

The formula in B1 will usually return a zero value. And the formula in A1
will always have a result. The result will vary all the time. In some cases
the result will be longer then the width of the cell and i want the result in
A1 to be read clearly - meaning to write over the top of cell B1 as if there
was no formula.

When there is a result in B1 the result in A1 will ALWAYS be shorter then
the width of the cell so there will not be a need to over write.

Can Excel do this?
 
R

Rya05

Dear Stephen,

I'm not sure if there are any formula / formatting that can do that. But
what I usually do is click cell A, then right click, choose format cell -->
alignment --> click at the option "wrap text" (make sure there is a tick in
the box)

hope this help.
 
D

Duke Carey

No, Excel will not do that. You must adjust the column width so that it
accommodates the length of result you expect.
 
Top