ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Printing "Freeze Panes" (https://www.excelbanter.com/excel-worksheet-functions/192639-printing-freeze-panes.html)

sh2195

Printing "Freeze Panes"
 
Is it possible to print my document so that the same (heading) row is at the
top of each new page? Something like what is achieved using the "freeze
panes" option, but on the hard copy. I can't just use the header to achieve
my intended result.
thanks!

Marcelo

Printing "Freeze Panes"
 
select FILE on the menu and PAGE SETUP, on the sheet tab, select the rows to
repeat at top.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sh2195" escreveu:

Is it possible to print my document so that the same (heading) row is at the
top of each new page? Something like what is achieved using the "freeze
panes" option, but on the hard copy. I can't just use the header to achieve
my intended result.
thanks!


Ernie Lippert

Printing "Freeze Panes"
 
Yes, you can. Go to ToolsPage SetupSheet then use Rows to repeat at top to
select the heading you want on each new pare.
Regards,
Ernie Lippert

"sh2195" wrote in message
...
Is it possible to print my document so that the same (heading) row is at
the
top of each new page? Something like what is achieved using the "freeze
panes" option, but on the hard copy. I can't just use the header to
achieve
my intended result.
thanks!




j B

Yes, you can.
 
Thank you! This is so helpful. I used this to create a tracking worksheet with a lot of inputs for a calendar.

In some ways it's also like "split view", in that it keeps the same stuff at the start of every page.

#split_view #freeze_panes #print_panes #print_freeze

On Wednesday, June 25, 2008 2:16 PM sh219 wrote:


Is it possible to print my document so that the same (heading) row is at the
top of each new page? Something like what is achieved using the "freeze
panes" option, but on the hard copy. I can't just use the header to achieve
my intended result.
thanks!



On Wednesday, June 25, 2008 2:28 PM Marcel wrote:


select FILE on the menu and PAGE SETUP, on the sheet tab, select the rows to
repeat at top.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sh2195" escreveu:



On Wednesday, June 25, 2008 2:38 PM Ernie Lippert wrote:


Yes, you can. Go to ToolsPage SetupSheet then use Rows to repeat at top to
select the heading you want on each new pare.
Regards,
Ernie Lippert






All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com