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.
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.)
Ok, I’ll give it a try. Thanks.
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.
Thank you, I will check it out.