Excel: cell size that changes depending on the PC?
warstick
-
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
Hello,
I'm facing a bit of a strange problem...
I created an Excel file on one PC where the row height of the cells is set to 14.3 and the column width is set to 1.93. The cells are therefore perfectly square.
I copy this file to a second different PC, and when I open it, the cell sizes are changed!
The height goes to 15 and the column width to 1.86! The cells are no longer square, and this distorts the shapes drawn on the sheet.
How is this possible? And how can I fix it? For example, by locking the cell dimensions, but how do I do that? I tried protecting the sheet, but that still has no effect; the size always varies from one PC to another.
Thank you.
I'm facing a bit of a strange problem...
I created an Excel file on one PC where the row height of the cells is set to 14.3 and the column width is set to 1.93. The cells are therefore perfectly square.
I copy this file to a second different PC, and when I open it, the cell sizes are changed!
The height goes to 15 and the column width to 1.86! The cells are no longer square, and this distorts the shapes drawn on the sheet.
How is this possible? And how can I fix it? For example, by locking the cell dimensions, but how do I do that? I tried protecting the sheet, but that still has no effect; the size always varies from one PC to another.
Thank you.
4 answers
Hello,
we can assume that it depends on the screen resolution, which is different.
The displayed size depends on the pixel density and varies from one to another.
eric
--
By trying continuously, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to saying thank you (yes, it can be done!!!), remember to set it to resolved. Thank you.
we can assume that it depends on the screen resolution, which is different.
The displayed size depends on the pixel density and varies from one to another.
eric
--
By trying continuously, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to saying thank you (yes, it can be done!!!), remember to set it to resolved. Thank you.
The report is that on a monitor you use whole pixels.
If on one monitor it is 0.15 and 0.16 on the other, you can see that this creates a gap that will widen with distance.
There's hardly any other solution than to have monitors with the same characteristics.
Calculating the adjustment to be made through a macro according to these is quite complex. Have fun doing a Google search about it.
eric
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to put it as resolved. Thank you.
If on one monitor it is 0.15 and 0.16 on the other, you can see that this creates a gap that will widen with distance.
There's hardly any other solution than to have monitors with the same characteristics.
Calculating the adjustment to be made through a macro according to these is quite complex. Have fun doing a Google search about it.
eric
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to put it as resolved. Thank you.
Hello,
do values remain fixed simply?
If by using VBA code upon opening the file
An example of code:
do values remain fixed simply?
If by using VBA code upon opening the file
An example of code:
Sub test() 'height=14.3 and width=1.93 Columns("A:A").ColumnWidth = 1.93 Rows("1:1").RowHeight = 14.3 End Sub
Hello,
Open your file
Alt+F11 to open the VBA window
double click on ThisWorkbook at the top left
A window opens on the right
Paste this code, adjusting as you wish:
Save as xlsm not xlsx
Open your file
Alt+F11 to open the VBA window
double click on ThisWorkbook at the top left
A window opens on the right
Paste this code, adjusting as you wish:
Private Sub Workbook_Open() 'height=14.3 and width=1.93 With Worksheets("my sheet") 'adapt the range of columns .Columns("A:A").ColumnWidth = 1.93 .Rows("1:1").RowHeight = 14.3 End With End Sub Save as xlsm not xlsx
Thank you.
I will ultimately give up on the idea because it doesn’t solve my problem; it’s more serious than that. In fact, if I perfectly adjust the cells on my sheet, the print preview (and thus the printing) is distorted. I am therefore forced to readjust my cells. I don’t know why there is a difference between my Excel sheet and the print preview!
I will ultimately give up on the idea because it doesn’t solve my problem; it’s more serious than that. In fact, if I perfectly adjust the cells on my sheet, the print preview (and thus the printing) is distorted. I am therefore forced to readjust my cells. I don’t know why there is a difference between my Excel sheet and the print preview!
For me, it's that Excel puts the possible approximate values according to the monitor.
--
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it will work. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to set it to resolved. Thank you.
--
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it will work. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to set it to resolved. Thank you.
And surprising that Microsoft didn't think of that?