ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How reset margins in Excel workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/24025-how-reset-margins-excel-workbook.html)

KYgirl

How reset margins in Excel workbook?
 
merged data with varying number of columns, reset page size to permit highest
number of columns but margins do not recognize pages with these large number
of columns, i.e., drops last 5 columns.

Dave Peterson

Maybe it's the print range that's the trouble.

File|Print Area
(set it to what you want--or clear it and let excel guess)

KYgirl wrote:

merged data with varying number of columns, reset page size to permit highest
number of columns but margins do not recognize pages with these large number
of columns, i.e., drops last 5 columns.


--

Dave Peterson


All times are GMT +1. The time now is 08:11 AM.

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