# Microsoft Excel 97 **URL:** \ **Category:** Factual Questions\ **Created:** [August 17, 2002, 6:36pm UTC](https://boards.straightdope.com/t/microsoft-excel-97/124372 "2002-08-17T18:36:27Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Nobody](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@Nobody](https://boards.straightdope.com/u/Nobody)\ **Post date:** [August 17, 2002, 6:36pm UTC](https://boards.straightdope.com/t/microsoft-excel-97/124372/1 "2002-08-17T18:36:27Z")
I mostly know how to use Excel 97, but there’s one thing I can’t figure out. How to name a column. For example, if I wanted to store information on my music collection, instead of working with _A\_B\_C\_D\_E 1_\_| **|** |\_ 2\_\_| **|** |\_ 4\_\_| **|** |\_ 5\_\_| **|** |\_ I’d want something more like _Artist\_Album\_Year 1_\_\_\_\_|**_|_ 2 **\_\_\_|** _|_ 3 **\_\_\_|** _|_ 4 **\_\_\_|** _|_ 5 **\_\_\_|\_\__** |**_ Or something like that. Anyway, how do I go about changing the column names? Thank you. ---
**Author:** ![tomndebb](https://avatars.discourse-cdn.com/v4/letter/t/b9e5f3/32.png) [@tomndebb](https://boards.straightdope.com/u/tomndebb)\ **Post date:** [August 17, 2002, 7:28pm UTC](https://boards.straightdope.com/t/microsoft-excel-97/124372/2 "2002-08-17T19:28:28Z")
I insert a new row 1 (or place the labels in row 1 before populating the rest of the sheet). Then (for printing), I select **File** ==\> **Page Setup** ==\> **Sheet**. On the **Sheet** tab, there is a **Print titles** section allowing you to specify titles in either rows or columns to be repeated on each page. Click once inside the rows window to change focus to the selection of rows, then click anywhere on the first row to have Excel create an automatic function to select that row. (You do not have to select Row 1: you can select a lower row (if, for example, you are going to have a non-repeating title at the top of the first page). You can also drag the cursor across multiple rows to select a title that is multiple rows deep.) ---
**Author:** ![Nobody](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@Nobody](https://boards.straightdope.com/u/Nobody)\ **Post date:** [August 17, 2002, 7:34pm UTC](https://boards.straightdope.com/t/microsoft-excel-97/124372/3 "2002-08-17T19:34:40Z")
Ok, I’ll give it a try. Thanks. ---
**Author:** ![rowrrbazzle](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/rowrrbazzle/32/414_2.png) [@rowrrbazzle](https://boards.straightdope.com/u/rowrrbazzle)\ **Post date:** [August 17, 2002, 11:27pm UTC](https://boards.straightdope.com/t/microsoft-excel-97/124372/4 "2002-08-17T23:27:14Z")
To affect the screen only, use the “freeze panes” feature. Type the column headings in row 1. Then position in cell A2. Now on the menu-bar, click “Window”. On the “Window” drop-down menu, click “Freeze Panes”. Now as you scroll down, row 1 will remain on the screen. Read the help entries on this function for more info. ---
**Author:** ![Nobody](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@Nobody](https://boards.straightdope.com/u/Nobody)\ **Post date:** [August 18, 2002, 8:05pm UTC](https://boards.straightdope.com/t/microsoft-excel-97/124372/5 "2002-08-18T20:05:38Z")
Thank you, I will check it out.