Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am a new user of MS Office Excel 2003. I know nothing about programming
language. I already used the Help menu and couldn't find an answer. I was hoping to find among the menu choices a command that would let me replace (what I think are called) worksheet column headers (A, B, C, etc.) with names for the columns (Box, Remarks, Amount, etc.). I want to do this so I can print a worksheet in which column header names (rather than letters) appear at the top of each printed sheet. If all I can do is name a column by naming a range of cells within the worksheet, then the name of the column only appears on the first printed page. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
No can do. However you can put your headers in the first row and hide the
rows/columns -- Don Guillett SalesAid Software "Tom McGuire" <Tom wrote in message ... I am a new user of MS Office Excel 2003. I know nothing about programming language. I already used the Help menu and couldn't find an answer. I was hoping to find among the menu choices a command that would let me replace (what I think are called) worksheet column headers (A, B, C, etc.) with names for the columns (Box, Remarks, Amount, etc.). I want to do this so I can print a worksheet in which column header names (rather than letters) appear at the top of each printed sheet. If all I can do is name a column by naming a range of cells within the worksheet, then the name of the column only appears on the first printed page. |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thanks for the reply. I was afraid I couldn't do it, but Bald Eagle 49 told
me how to do what I wanted. McGuire "Don Guillett" wrote: No can do. However you can put your headers in the first row and hide the rows/columns -- Don Guillett SalesAid Software "Tom McGuire" <Tom wrote in message ... I am a new user of MS Office Excel 2003. I know nothing about programming language. I already used the Help menu and couldn't find an answer. I was hoping to find among the menu choices a command that would let me replace (what I think are called) worksheet column headers (A, B, C, etc.) with names for the columns (Box, Remarks, Amount, etc.). I want to do this so I can print a worksheet in which column header names (rather than letters) appear at the top of each printed sheet. If all I can do is name a column by naming a range of cells within the worksheet, then the name of the column only appears on the first printed page. |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thank you very much!!! It works!
McGuire "Bald Eagle 49" wrote: As Don says put your headers in the first row. To print your headers on each page to FILE - Page Setup - Sheet and complete teh section under print titles "Don Guillett" wrote: No can do. However you can put your headers in the first row and hide the rows/columns -- Don Guillett SalesAid Software "Tom McGuire" <Tom wrote in message ... I am a new user of MS Office Excel 2003. I know nothing about programming language. I already used the Help menu and couldn't find an answer. I was hoping to find among the menu choices a command that would let me replace (what I think are called) worksheet column headers (A, B, C, etc.) with names for the columns (Box, Remarks, Amount, etc.). I want to do this so I can print a worksheet in which column header names (rather than letters) appear at the top of each printed sheet. If all I can do is name a column by naming a range of cells within the worksheet, then the name of the column only appears on the first printed page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel worksheet display #### | Excel Discussion (Misc queries) | |||
How do I change letters at top of excel to custom headers | Excel Worksheet Functions | |||
Can I change the left margin for headers in excel | Excel Discussion (Misc queries) | |||
On a excel protected worksheet, how do I change the tab order? | Excel Worksheet Functions | |||
EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) |