how do you move rows onto the next page in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top