hi,
i have a long list of names (150 and more) that i want to sort (have
done that) and then print one name per page. to insert page breaks i
have dragged the page break to where i want it but it seems there
should be some other short cut to apply that to the whole page. any
suggestions? i tried help and have also tried copying the format but it
has not worked. i'd rather not spend the time dragging 150 page breaks
around!
thanks,


--
ZWILLINGE
------------------------------------------------------------------------
ZWILLINGE's Profile: http://www.excelforum.com/member.php...o&userid=26837
View this thread: http://www.excelforum.com/showthread...hreadid=400816

You could insert a pagebreak where you want it.

Then select the next location and hit F4 (repeat that action).

Or you could drop the pagebreaks completely and just print each row using a
macro:

Option Explicit
Sub testme()

Dim iRow As Long
Dim FirstRow As Long
Dim LastRow As Long

With ActiveSheet
FirstRow = 2 'headers in row 1???
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

For iRow = FirstRow To LastRow
.Rows(iRow).PrintOut preview:=True
Next iRow
End With
End Sub

I used column A to determine the last row to print and did a preview (to save
paper).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



ZWILLINGE wrote:

hi,
i have a long list of names (150 and more) that i want to sort (have
done that) and then print one name per page. to insert page breaks i
have dragged the page break to where i want it but it seems there
should be some other short cut to apply that to the whole page. any
suggestions? i tried help and have also tried copying the format but it
has not worked. i'd rather not spend the time dragging 150 page breaks
around!
thanks,

--
ZWILLINGE
------------------------------------------------------------------------
ZWILLINGE's Profile: http://www.excelforum.com/member.php...o&userid=26837
View this thread: http://www.excelforum.com/showthread...hreadid=400816

--

Dave Peterson