Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting cells
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting cells
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. -- :) "StephenAccountant" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting cells
No, Excel will not do that. You must adjust the column width so that it
accommodates the length of result you expect. "StephenAccountant" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Users overwriting cells with Validation set to "Lists" | Excel Discussion (Misc queries) | |||
Overwriting #DIV/0 value using ISERROR | Excel Discussion (Misc queries) | |||
repeating data in column to empty cells below without overwriting | Excel Worksheet Functions | |||
Alert before overwriting cells | Excel Discussion (Misc queries) | |||
Overwriting Cells | Excel Discussion (Misc queries) |