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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comments partially hidden due to "frozen" columns 2
Scrolling Behavior 1
How do I freeze/ unfreeze a window pane in Excel 2007? 2
Change scroll rows from 1 to 3 with mouse wheel 1
hidden top row?? 9
How to fix the top-most 4 rows when scrolling? 1
Excel 2007 compatibility issue - speed between cells 2
Missing Column Headers / Can't scroll to top 2

Back
Top