Formula bar covering column headers

H

Hanr3

How do I set up the formula bar so it doesn't cover the cloumn headers?


Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.
 
G

Gord Dibben

I assume you mean when you have a lot of text in the formula bar.

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

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

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

Window>New Window>Arrange>Horizontal.

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




How do I set up the formula bar so it doesn't cover the cloumn headers?


Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.
Click to expand...

Gord Dibben MS Excel MVP
 
Top