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.

You can highlight the cells that are a problem and use FormatCells... and
check Hidden and then protect the worksheet, using ToolsProtectionProtect
worksheet...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hanr3" wrote in message
...
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.

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

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, 13 Jun 2006 07:06:02 -0700, Hanr3
wrote:

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