How do I wrap rows in Excel so all column data is printed on 1 pg

J

JonnyVExcel101

nIf I am working on an excel worksheet, and have 20 columns with data and
would like to WRAP it so it prints on one page maybe in 2 or more printed
rows before row 2 of my worksheet prints, is there a way of putting is a "row
break"?

Is this something that can be done in Excel, or am I forced to use Acess?
This may be a stupid question as a self taught Excel user, but any ideas
would be appreciated.
 
K

KC

Jonny,
i'm not sure if this is what your looking for, but have you tried under View
menu -> Page Break Preview.
and right click on the sheet and click 'Insert Page Break'

Regards,
-kc
*click YES if it works
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rows reappear on pages when printed 1
In Excel, how do I print the cell blocks as well as the data? 2
Worksheet looks good in print, not so good on-screen 6
Row 1 HEADERS on EVERY printed page 2
Arggh! Each row prints on separate page 2
Excel: Repeating Row 1 Content at top of all printed pages 2
Printing on a pre-printed worksheet in excel 2003 2
How do I, not print hidden rows (Excel) 2

Top