ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   optimising column width & row height (https://www.excelbanter.com/new-users-excel/179585-optimising-column-width-row-height.html)

KRK

optimising column width & row height
 
Hello,

I have a table whose cells contain text. The lengths of the text strings are
unpredictable, and vary quite widely between different records.

To minimise the overall size of the table (for printing) I use 'wrap text'
, and I juggle column width and row height by double-clicking on the
row/column boundaries. This works, but I cannot seem to find an optimum, and
every time I add new records I have to start again.

Any ideas how to optimise the table size please ?

Thanks

KK


Dave[_6_]

optimising column width & row height
 
Hi KK,
How many columns of data is involved and what restrictions do you want
to set on the number of pages across when the sheet is printed?
Dave.

KRK

optimising column width & row height
 
Hello,

There are 9 columns, and I would prefer to minimise the total number of
sheets of paper.

Thanks

K

"Dave" wrote in message
...
Hi KK,
How many columns of data is involved and what restrictions do you want
to set on the number of pages across when the sheet is printed?
Dave.




All times are GMT +1. The time now is 12:07 AM.

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