Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat the 1st column on the following pages in Excel?
When I print my Excel spreadsheet I would like to show the first column of
data on all the following printed pages. I can see how to freeze the first column so when looking at it online I can always see the first column - is there a way to print it this way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat the 1st column on the following pages in Excel?
File | Page Setup | Sheet tab | Columns to repeat
Regards Trevor "Penny Reynolds" <Penny wrote in message ... When I print my Excel spreadsheet I would like to show the first column of data on all the following printed pages. I can see how to freeze the first column so when looking at it online I can always see the first column - is there a way to print it this way? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat the 1st column on the following pages in Excel
Thanks, Trevor, I did this earlier but I guess I don't know what value is
expected. I tried "A" (for column A) and also the title of my column but got the error that the it was not a valid reference or defined name. Is there something else I need to set up first? "Trevor Shuttleworth" wrote: File | Page Setup | Sheet tab | Columns to repeat Regards Trevor "Penny Reynolds" <Penny wrote in message ... When I print my Excel spreadsheet I would like to show the first column of data on all the following printed pages. I can see how to freeze the first column so when looking at it online I can always see the first column - is there a way to print it this way? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat the 1st column on the following pages in Excel
$A:$A
The easiest way is to click inside the box and then select the column ... it will fill it in for you. Regards "Penny Reynolds" wrote in message ... Thanks, Trevor, I did this earlier but I guess I don't know what value is expected. I tried "A" (for column A) and also the title of my column but got the error that the it was not a valid reference or defined name. Is there something else I need to set up first? "Trevor Shuttleworth" wrote: File | Page Setup | Sheet tab | Columns to repeat Regards Trevor "Penny Reynolds" <Penny wrote in message ... When I print my Excel spreadsheet I would like to show the first column of data on all the following printed pages. I can see how to freeze the first column so when looking at it online I can always see the first column - is there a way to print it this way? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat the 1st column on the following pages in Excel
Penny
Try A:A or just point to the column using the collapse button at right side of the dialog box. I call it the collapse button because no one ever told me the real name for it. Gord Dibben MS Excel MVP On Fri, 1 Sep 2006 11:06:02 -0700, Penny Reynolds wrote: Thanks, Trevor, I did this earlier but I guess I don't know what value is expected. I tried "A" (for column A) and also the title of my column but got the error that the it was not a valid reference or defined name. Is there something else I need to set up first? "Trevor Shuttleworth" wrote: File | Page Setup | Sheet tab | Columns to repeat Regards Trevor "Penny Reynolds" <Penny wrote in message ... When I print my Excel spreadsheet I would like to show the first column of data on all the following printed pages. I can see how to freeze the first column so when looking at it online I can always see the first column - is there a way to print it this way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel printing "additional" blank pages? | Excel Discussion (Misc queries) | |||
How can I setup in Excel Worksheet Column a number is not repeat? | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |