Excel 2007 Can't scroll to top row which is partially hidden
 

I'm using Excel 2007 - and the top row of my spreadsheet is partially hidden
by the formula bar - I don't seem to be able to scroll up to it - this is
absolutely weird - I am a very experienced Excel user and just moved to 2007
from 2003.

Thanks

Excel 2007 Can't scroll to top row which is partially hidden
 

Hi

Do you have a Table on the sheet?
If so, this is a (nice) feature of XL2007. As you scroll down the table,
once you get below one screen of data, the headings replace the Column
letters.
Scroll back up to row 1 and your column labels will reappear, with your
header row beneath them.

The formula bar itself is now sizeable (another nice feature). If you
hover over the bottom edge of the formula bar until you get a double
sided arrow, then drag down, the formula bar will increase in depth. It
does not, however, cover the column headings.
--
Regards

Roger Govier


"grandad" wrote in message
...
I'm using Excel 2007 - and the top row of my spreadsheet is partially
hidden
by the formula bar - I don't seem to be able to scroll up to it - this
is
absolutely weird - I am a very experienced Excel user and just moved
to 2007
from 2003.

Thanks