Formula bar covering column headers

[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.

 

[Nick Hodge]

You can highlight the cells that are a problem and use Format>Cells...> and
check Hidden and then protect the worksheet, using Tools>Protection>Protect
worksheet...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[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.

Gord Dibben MS Excel MVP