Replace text with page break

[cass h]

I have a spreadsheet parsed from downloaded data. In a row by itself
have text that exists only in rows I want to replace with a page break
I have tried find/replace and it didn't work because I couldn't us
the ^m function like I can in Word.

Can anyone tell me how to replace these characters with page breaks s
I can print my spreadsheet on a form correctly?

Thanks all

 

[RagDyer]

I don't quite follow you, but might this help?

Click <View> <PageBreakPreview>,
And click and drag your page breaks anywhere to your hearts content.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a spreadsheet parsed from downloaded data. In a row by itself I
have text that exists only in rows I want to replace with a page break.
I have tried find/replace and it didn't work because I couldn't use
the ^m function like I can in Word.

Can anyone tell me how to replace these characters with page breaks so
I can print my spreadsheet on a form correctly?

Thanks all!