| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
print heading row on every page
I followed the instructions for getting a heading row to repeat on every
page, but I couldn't get it to work. |
|
#2
|
|||
|
|||
|
In order to have rows repeat on every page, Go to File/Page Setup/Sheet and
select the rows to repeat at top. "Betty" wrote: I followed the instructions for getting a heading row to repeat on every page, but I couldn't get it to work. |
|
#3
|
|||
|
|||
|
Hmm....be more specific on what are you getting. Anyway... File - Page Setup - Sheet - Print title: "Rows to repeat at top" Betty Wrote: I followed the instructions for getting a heading row to repeat on every page, but I couldn't get it to work. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388731 |
|
#4
|
|||
|
|||
|
"Morrigan" wrote: Hmm....be more specific on what are you getting. Anyway... File - Page Setup - Sheet - Print title: "Rows to repeat at top" I did this and then typed in A1:H1. Was that the wrong way to do it? I simply got no heading on the 2nd page. -Betty Betty Wrote: I followed the instructions for getting a heading row to repeat on every page, but I couldn't get it to work. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388731 |
|
#5
|
|||
|
|||
|
File - Page setup - Sheet. Collapse using the Rows to repeat at top and then
select the rows with your cursor. -- Sincerely, Michael Colvin "Betty" wrote: "Morrigan" wrote: Hmm....be more specific on what are you getting. Anyway... File - Page Setup - Sheet - Print title: "Rows to repeat at top" I did this and then typed in A1:H1. Was that the wrong way to do it? I simply got no heading on the 2nd page. -Betty Betty Wrote: I followed the instructions for getting a heading row to repeat on every page, but I couldn't get it to work. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388731 |
|
#6
|
|||
|
|||
|
The notation for the first row only would be $1:$1, or simply just select with your mouse. Betty Wrote: "Morrigan" wrote: Hmm....be more specific on what are you getting. Anyway... File - Page Setup - Sheet - Print title: "Rows to repeat at top" I did this and then typed in A1:H1. Was that the wrong way to do it? I simply got no heading on the 2nd page. -Betty Betty Wrote: I followed the instructions for getting a heading row to repeat on every page, but I couldn't get it to work. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388731 -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388731 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tOTALS WON'T PRINT ON SAME PAGE | New Users to Excel | |||
| How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
| My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
| print selected sections on the same page | Excel Discussion (Misc queries) | |||
| Getting rid of 2nd Page on Print. | New Users to Excel | |||
Linear Mode
