ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do you move rows onto the next page in excel (https://www.excelbanter.com/excel-worksheet-functions/160756-how-do-you-move-rows-onto-next-page-excel.html)

Candice

how do you move rows onto the next page in excel
 
I'm tring to make a supplies list for my office, but I want the title
"supplies List " on the next couple of pages, and I'm wondering how do you do
that.

tim m

how do you move rows onto the next page in excel
 
Can you elaborate? You want the Title to be on a few worksheets? Or is this
for printing purposes? Or do you just want a new title as you scroll down
your worksheet?

"Candice" wrote:

I'm tring to make a supplies list for my office, but I want the title
"supplies List " on the next couple of pages, and I'm wondering how do you do
that.


Rajat

how do you move rows onto the next page in excel
 
If it is for printing purpose then you can try folllowing -
1. Set it as header File Page Setup Header & Footer (Tab Click)
and write down "supplies List' (Click ok) use this option if your text
is not in the Sheets. But this will print in every page printed from this
worksheet.

2. Another way is File Page Setup Sheet (Tab Click)
Click on the Row to Repete/ and select the row in the sheet.
But this will also the text selected in every page printed from this
worksheet.

regards
Rajat



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

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