General Chat

Top tip - using the Genes Reunited community

Welcome to the Genes Reunited community boards!

  • The Genes Reunited community is made up of millions of people with similar interests. Discover your family history and make life long friends along the way.
  • You will find a close knit but welcoming group of keen genealogists all prepared to offer advice and help to new members.
  • And it's not all serious business. The boards are often a place to relax and be entertained by all kinds of subjects.
  • The Genes community will go out of their way to help you, so don’t be shy about asking for help.

Quick Search

Single word search

Icons

  • New posts
  • No new posts
  • Thread closed
  • Stickied, new posts
  • Stickied, no new posts

Excell help please

ProfilePosted byOptionsPost Date

AnninGlos

AnninGlos Report 11 May 2011 15:27

I know I knew this but have forgotten. Doing a spread sheet, how do I get the first (title) line of cells to remain static while the reat scrolls down?

InspectorGreenPen

InspectorGreenPen Report 11 May 2011 15:36

Select the left most cell immediately below the title row. Then click on Window and select Freeze Panes.

If you also want to fix a column titles on the left, then select the cell immediately below your header rows and immediately to the right of your column titles.

AnninGlos

AnninGlos Report 11 May 2011 16:13

Thank you that is a great help