An Excel Question

  JayDay 09:50 18 Feb 05
Locked

I have created a a large spreadsheet and would like the column headings to remain static whilst I scroll down and view the data. I hope this makes sense. I am getting frustrated at having to keep scrolling back up a hundred rows to find out what the column heading is!

I have seen this before so I know it can be done just can't work out how to do it.

  geeza 09:52 18 Feb 05

click window on the menu bar and freeze panes

  geeza 10:05 18 Feb 05

If you are happy with the answere please use the green tick

  The BB 10:05 18 Feb 05

.. or Windows->Split and move the horizontal/vertical to give the split you want

  Graham ® 10:06 18 Feb 05

As above, select the cell below and to the right of where you want the freeze.

  end 10:07 18 Feb 05

vog may be around soon to give you his expert input if you are still stuck::)))

  brambles 10:10 18 Feb 05

Geeza is quite correct but obviously you must be in the correct cell before freezing the panes.

If your headings e on Row 1 then put the cursor in 2A then, as Geeza says click on Windows in the title bar & freeze frames.

Brambles

  JayDay 10:15 18 Feb 05

Thanks everyone. Geeza's solution was exactly what I was looking for. Brambles thanks for the extra bit.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…