Placing headings automatically at page breaks

M

mike

Hello,
Since I have a large spreadsheet with lots of page breaks. I would like
to know is there a easy way to add all the heading names automatically to
move to the first line of the page break. Doing it manually right now is
very time consuming.
ex:
test test test test
0 o x x
7 j h d
-------------------------------------------- page break
test test test test I want this heading
here
thanks
 
D

DDM

Mike, File > Page Setup > Sheet. In the Rows to repeat at top field, enter
$1:$1 if you want only the first row to repeat, $1:$2 for the first two
rows, $1:$3 (you get the idea)... Then OK.
 
Top