Title row in excel 2010 sheet?!

**jakobstrom** · 06-10-2011, 06:16 AM

I am working with a (soon quite large) excel sheet for data collection. Each column (A to BH) is a category, and each row will correspond to one individual. In the end I will probably end up with 3-600 rows, so I want to do my best to make this as effective as possible. The first three rows contain information about the contents of the different columns. My problem is that when scolling down in excel, you lose sight of the first row, meaning that I either must remember exactly what is supposed to be in each column, or scroll up every single time I forget.

So: is there a way to either rename the columns (from e.g. "A" to "Name") or to make the first row follow when you scroll down?

Sorry if this is already in another thread, but I couldn't find any such.

**TMS** · 06-10-2011, 06:21 AM

Use the View Ribbon and choose Freeze Panes. Fix the top few rows and they'll stay visible.

Regards

**jakobstrom** · 06-10-2011, 06:25 AM

Great! Thanks a lot!

**TMS** · 06-10-2011, 06:27 AM

You're welcome.

If this has answered your question, please mark your thread as solved. See my signature for details or the FAQ.

Regards

**teylyn** · 06-10-2011, 06:27 AM

The first three rows contain information about the contents of the different columns.

Refining TMShucks' suggestion:

You can freeze the first three rows this way:

- select cell A4
- click the View Ribbon > Freeze Panes > Freeze panes.

If your sheet also extends to the right and you want to keep column A visible at the left, then select cell B4 before freezing the panes. (anyone notice the pun?) If you already have frozen panes, you first need to Unfreeze then select the top right cell of the scrollable area and freeze panes again.

cheers,