Kim,
Here is a macro that will accomplish what you are asking for. What it does
is add a page break on every row for all used cells.
Go to VBA (Tools>Macro>Visual Basic Editor) and create a new Module for the
coding (Insert>Module) and paste this code in, close VBA.
Run the Macro from Excel (Tools>Macro>Macros>Add_PageBreaks)
Public Sub Add_PageBreaks()
Dim xlssheet As Worksheet
Set xlssheet = Excel.ActiveSheet
Dim x As Long
Dim y As Long
Dim actcell As String
y = xlssheet.UsedRange.Rows.Count
For x = 2 To y
actcell = "$A$" & x
xlssheet.Range(actcell).Select
ActiveWindow.SelectedSheets.HPageBreaks.Add before:=ActiveCell
Next
End Sub