ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Repeating first Row AND first column on every page (https://www.excelbanter.com/excel-discussion-misc-queries/176672-repeating-first-row-first-column-every-page.html)

Sean3DD

Repeating first Row AND first column on every page
 
Using page setup I can select the first 'row to repeat at top' and then
select the first 'column to repeat at left', $1:$1 and $A:$A.

However when I go to print, the column info is carried over to each page but
the row info is not.

Is this a limitation of Excel or am I doing something wrong ?

regards to all

Dave Peterson

Repeating first Row AND first column on every page
 
Or maybe your data isn't more than one page wide?



Sean3DD wrote:

Using page setup I can select the first 'row to repeat at top' and then
select the first 'column to repeat at left', $1:$1 and $A:$A.

However when I go to print, the column info is carried over to each page but
the row info is not.

Is this a limitation of Excel or am I doing something wrong ?

regards to all


--

Dave Peterson


All times are GMT +1. The time now is 09:50 AM.

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