Well, you could always make the spreadsheet not fill the Excel main window.
Either use the spreadsheet's "Restore Window" icon in the upper right corner
or just click Window/Arrange from Excel's menu bar and OK any of the options
on the panel that appears; then resize the window so the formula bar
drop-down doesn't cover anything.

Rick


"AC70" wrote in message
...
When I click F2 to try and edit a long, multi-line formula and trace the
various dependents, the formula covers the column headers, making it
impossible to follow the dependent cells. Is there a setting I can modify
to
make sure both the formula and the column headers are visible in edit mode
(without having to resort to edit in cell)?

Thanks