ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I distribute columns evenly within the printable area XLS 03 (https://www.excelbanter.com/excel-discussion-misc-queries/249883-can-i-distribute-columns-evenly-within-printable-area-xls-03-a.html)

Fiona4114

Can I distribute columns evenly within the printable area XLS 03
 
I want to automatically distribute my columns evenly in a workseet so they
fit the page, like you can with tables in Word. Does anyone know if this is
even possible in Excel 2003?

Bernard Liengme

Can I distribute columns evenly within the printable area XLS 03
 
If you have MORE columns that will fit a page width, then in Page Setup you
can specify that the print is to be 1 page wide
If you have LESS, then in the same dialog you could experiment with making
the print 110%, 120% etc
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Fiona4114" wrote in message
...
I want to automatically distribute my columns evenly in a workseet so they
fit the page, like you can with tables in Word. Does anyone know if this
is
even possible in Excel 2003?




All times are GMT +1. The time now is 06:58 AM.

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