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.

Samsung Galaxy S8 review

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

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes