Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replace the column letters with my own heading
I want to know how i can i replace the column letters so i can put in my
heading so that i always know which coumn i'm in and which question i'm answering when i'm entering data further down the page. Or any way that i can get my headings to follow down the page as i'm entering data so i can always see it no matter how many rows down i am. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replace the column letters with my own heading
If your headings are in row 1
Click in cell A2 and Goto WindowFreeze Panes. Freeze Panes freezes anything above and to the left of the active cell. HTH Martin "Catter77" wrote in message ... I want to know how i can i replace the column letters so i can put in my heading so that i always know which coumn i'm in and which question i'm answering when i'm entering data further down the page. Or any way that i can get my headings to follow down the page as i'm entering data so i can always see it no matter how many rows down i am. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replace the column letters with my own heading
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replace the column letters with my own heading
Hi,
In 2007 if you define your range as a table and scroll down the titles will automatically replace the column letters when they move out of view. Otherwise Window, Freeze Panes is the method of choice. -- Cheers, Shane Devenshire "Catter77" wrote: I want to know how i can i replace the column letters so i can put in my heading so that i always know which coumn i'm in and which question i'm answering when i'm entering data further down the page. Or any way that i can get my headings to follow down the page as i'm entering data so i can always see it no matter how many rows down i am. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to replace numeric values with letters in a diagram? | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
How to change collumn heading numbers into letters? | Excel Discussion (Misc queries) | |||
In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
Looking for an easy way to replace letters with acutes | Excel Worksheet Functions |