View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how to stop long formulas from obscuring column letters?

Resize the Window so you're not working in a maximized window.

Alternative..........................

A kludgy work-around............

WindowNew WindowArrangeHorizontal.

Arrange top window so's it covers 4 or 5 rows.

Work in the bottom window. Your long formulas will drop down into the top
window when you select a cell in lower window.


Gord Dibben Excel MVP

On Tue, 19 Dec 2006 14:39:01 -0800, GoBobbyGo
wrote:

how do I vertically enlarge the formula window, so that when i click on a
cell with a long formula in it, the formula doesn't cover up the column
headers?


Gord Dibben MS Excel MVP