ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   adding row headings to multiple pages - how do i input the rows? (https://www.excelbanter.com/new-users-excel/89353-adding-row-headings-multiple-pages-how-do-i-input-rows.html)

connie

adding row headings to multiple pages - how do i input the rows?
 
I'm trying to add row headings to the page set up to add multiple pages. I
need to print rows 1, 2 and 3. What format do I use?

Miguel Zapico

adding row headings to multiple pages - how do i input the rows?
 
You can repeat rows on top in the File-Page setup-Sheet tab. In the "Rows
to repeat at top" enter $1:$3, and those rows will show in all the printed
pages.

Hope this helps,
Miguel.

"connie" wrote:

I'm trying to add row headings to the page set up to add multiple pages. I
need to print rows 1, 2 and 3. What format do I use?



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

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