ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing (https://www.excelbanter.com/excel-discussion-misc-queries/40231-printing.html)

nunoeca

Printing
 

Hi all,

I'm sorry to post on such a dumb question, but my brain is not
distinguishing the cells anymore... :)

I don't remember what I need to do in order to print the first two rows
on every page I print on a sheet.

I know where to do it (print preview setup, advanced), but I don't find
a way to unlock that option in order to repeat the rows on every page.

Can someone help me?

Thanks in advance.

Nuno Eça


--
nunoeca
------------------------------------------------------------------------
nunoeca's Profile: http://www.excelforum.com/member.php...o&userid=26200
View this thread: http://www.excelforum.com/showthread...hreadid=395461


Debra Dalgleish

In normal view, choose FilePage Setup
On the Sheet tab, set the rows to repeat at top
Click OK

nunoeca wrote:
Hi all,

I'm sorry to post on such a dumb question, but my brain is not
distinguishing the cells anymore... :)

I don't remember what I need to do in order to print the first two rows
on every page I print on a sheet.

I know where to do it (print preview setup, advanced), but I don't find
a way to unlock that option in order to repeat the rows on every page.

Can someone help me?

Thanks in advance.

Nuno Eça




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 10:44 PM.

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