ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I wrap rows in Excel so all column data is printed on 1 pg (https://www.excelbanter.com/excel-discussion-misc-queries/242311-how-do-i-wrap-rows-excel-so-all-column-data-printed-1-pg.html)

JonnyVExcel101

How do I wrap rows in Excel so all column data is printed on 1 pg
 
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.

KC

How do I wrap rows in Excel so all column data is printed on 1 pg
 
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
"JonnyVExcel101" wrote:

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.



All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com