ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   row headings on pages - proper formatting in page set up (https://www.excelbanter.com/excel-discussion-misc-queries/89329-row-headings-pages-proper-formatting-page-set-up.html)

connie

row headings on pages - proper formatting in page set up
 
I need to print row headings on each page of a spreadsheet. What is the
exact way to input rows 1, 2 and 3 in the page set up?

Michael

row headings on pages - proper formatting in page set up
 
Hi connie. From the file menu go to page setup and select the sheet tab.
Click on the red collapse arrow for the "rows to repeat at top:" box and then
select rows 1,2,3, click on the collapse arrow again and click ok. The first
three rows will then print on every page. HTH
--
Sincerely, Michael Colvin


"connie" wrote:

I need to print row headings on each page of a spreadsheet. What is the
exact way to input rows 1, 2 and 3 in the page set up?



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

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