# Cell dimensions and print scaling

#### Alex McLaren

##### New Member
Hi! I'm having a hard time with the way Excel scales worksheets for printing. I'm trying to create a narrative report which has 16 pages, to be printed first to a PDF using a virtual printer, and then on A4 paper using a plastic-and-circuit-boards printer. (Yes, it has to be created in Excel, although it's probably not the best tool for the job - don't ask...). I've used Excel for stuff like this before, but I've never quite been able to get the dimensions of the page perfect for printing without distortions from scaling.

I figured that a reasonable way to find out what Excel thinks a sheet of A4 looks like would be to set all column widths and row heights to 1, select a huge print area, and see how Excel broke it up into pages. The result was 70 column-width-units wide by more than 900 row-height-units tall, and on the screen, at least, it was about three times longer than A4 is, so I figure that's a bust.

I've investigated methods of defining row height and column width in centimetres. The dimensions of A4 are 21 x 29.7 cm. Setting the columns to 1 cm and the rows to 1.1 cm, then, you'd expect would give an A4 print area of 27 rows by 21 columns. Instead, it's 27 rows by 17 columns - 17 x 29.7 cm. Printed without margins on a sheet of A4, you'd expect this to result in a distorted print-out - it would have to be made 4 cm wider to fit the page exactly (I've set custom page margins to 0 on all sides).

I've tried similar methods using pixels etc. to similar effect. I'm guessing the issue is something to do with the fact that there are several resolutions at play - screen resolution, virtual printing resolution and actual printing resolution are presumably all factors in how Excel's cell dimension units translate into physical centimetres.

Does anyone know of a way to define a print area which corresponds exactly to 16 pages of A4 (or to an identical resolution to 16 pages of A4), broken up appropriately? It doesn't really matter how many rows and columns it has beyond more than a hundred being cumbersome and less than 20 being limiting in terms of formatting.

Thanks!

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Replies
0
Views
36
Replies
0
Views
40
Replies
1
Views
111
Replies
0
Views
105
Replies
0
Views
139

Threads
1,130,033
Messages
5,639,658
Members
417,104
Latest member
Nelsini

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back