Home |
Search |
Today's Posts |
#1
|
|||
|
|||
naming columns
how do i name columns & then repeat these heading on each page?
i tried excel help and went to page setup, then print titles, then rows to repeat, and i get "reference is not valid". can i change the column headings from "A, B, C,..." to specific headings that I want? thanks |
#2
|
|||
|
|||
aj
You cannot change the column letters from A, B, C etc. You can type titles in row 1 like Name, Address, Zip etc. To repeat these on each printed page you would enter $1:$1 in the "rows to repeat at top" box. Also in page setupsheet uncheck "row and column headings" Gord Dibben Excel MVP On Thu, 31 Mar 2005 11:39:03 -0800, "aj" wrote: how do i name columns & then repeat these heading on each page? i tried excel help and went to page setup, then print titles, then rows to repeat, and i get "reference is not valid". can i change the column headings from "A, B, C,..." to specific headings that I want? thanks |
#3
|
|||
|
|||
THANK YOU SO MUCH!!! THAT'S WHAT I NEEDED TO KNOW :-)
-- aj "Gord Dibben" wrote: aj You cannot change the column letters from A, B, C etc. You can type titles in row 1 like Name, Address, Zip etc. To repeat these on each printed page you would enter $1:$1 in the "rows to repeat at top" box. Also in page setupsheet uncheck "row and column headings" Gord Dibben Excel MVP On Thu, 31 Mar 2005 11:39:03 -0800, "aj" wrote: how do i name columns & then repeat these heading on each page? i tried excel help and went to page setup, then print titles, then rows to repeat, and i get "reference is not valid". can i change the column headings from "A, B, C,..." to specific headings that I want? thanks |
#4
|
|||
|
|||
You're welcome.
Thanks for the feedback. Gord On Thu, 31 Mar 2005 19:37:01 -0800, "aj" wrote: THANK YOU SO MUCH!!! THAT'S WHAT I NEEDED TO KNOW :-) -- aj "Gord Dibben" wrote: aj You cannot change the column letters from A, B, C etc. You can type titles in row 1 like Name, Address, Zip etc. To repeat these on each printed page you would enter $1:$1 in the "rows to repeat at top" box. Also in page setupsheet uncheck "row and column headings" Gord Dibben Excel MVP On Thu, 31 Mar 2005 11:39:03 -0800, "aj" wrote: how do i name columns & then repeat these heading on each page? i tried excel help and went to page setup, then print titles, then rows to repeat, and i get "reference is not valid". can i change the column headings from "A, B, C,..." to specific headings that I want? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming columns in excel (Name, Address, Phone, etc) | Excel Discussion (Misc queries) | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Lookup Data in Several Columns | Excel Worksheet Functions |