"Skiffie" wrote:

I've got a long formula in a cell that runs over to about 3 lines in the
formula bar. When the cell is selected, the formula bar expands over the
column headsing and some of the top row of cells, obscuring them. Is there
any way to stop this from occurring??

Insert a rectangle from the Drawing toolbar, and "copy" your formula on to
it. You can drag it close to the cell in question and examine the cell in
detail. You can also put markers or spaces into the boxed version to help
clarify something with lots of if-then's in it. Make the text bigger too if
it helps. For example (a real one!)

=IF(ISBLANK(H8), IF(OR(ISBLANK(I8),ISBLANK(J8)),"",I8*$Q$3),
IF(OR(ISBLANK(I8),ISBLANK(J8)),"" ,$Q$2+(I8-1)*$Q$3))