id="info"

Question

Locked

Excel column headings

By john.a.wills ·
I want to use as column headings the values in the first row of my file. I know this is possible, but I have forgotten how to do it. I am working in Excel 2007 home. The Help facility is, as often, useless.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

two otions here

by markp24 In reply to Excel column headings

Im going to provide two answers
1) if you want to Freeze the cells so while your scrolling in the work sheet you always see the headings or rows to the lelt.
a) please review this site "http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx"
here is a quote showing the details
Freeze panes to lock specific rows or columns
1.On the worksheet, do one of the following:
To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
.
.
2.On the View tab, in the Window group, click the arrow below Freeze Panes.
3.Do one of the following:
To lock one row only, click Freeze Top Row.
To lock one column only, click Freeze First Column.
To lock more than one row or column, or to lock both rows and columns at the same time, click Freeze Panes.


the other option to print the first row on every page, you want to goto page setup and under sheet select the rows to repeat

more details here
"http://www.lytebyte.com/2009/08/18/how-to-print-first-row-or-header-row-on-every-page-in-excel/"

Collapse -

Reponse To Answer

by john.a.wills In reply to two otions here

This is very good, but it isn't quite what I want. I am in fact using your first-provided option until I find a way of doing what I actually want to do: change the Excel column-heading texts.

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums