ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   problem with the headline!!!! (https://www.excelbanter.com/excel-discussion-misc-queries/215457-problem-headline.html)

bar

problem with the headline!!!!
 
how can i change the headline's definitions so it can fit to more then 1 page
in the spreadsheet?


bar

Shane Devenshire

problem with the headline!!!!
 
Hi,

What do you mean by Headlines? If you are trying to repeat a row in your
spreadsheet at the top of each page of a printout then choose File, Page
Setup, Sheet tab, and enter the row in the Rows to Repeat at top box, for
example, 1:1 would indicate you want row 1 repeated at top.

If you want a common title at the top of all pages then put it in the Custom
Header - File, Page Setup, Header and Footers tab, Custom Header...

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"bar" wrote in message
...
how can i change the headline's definitions so it can fit to more then 1
page
in the spreadsheet?


bar




All times are GMT +1. The time now is 12:22 AM.

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