On an Excel worksheet, I've got a whack of textboxes and am using AutoSize. When I change the zoom percent or print the document, the sizes (height, width) of some textboxes change.
As an example, here are the heights, widths of a given textbox at 100%, 400% and 25% zoom rates.
25% 66 105
100% 55.5 98.25
400% 54.75 94.5
I'm not sure yet, but perhaps changing the zoom rate changes the perceived size of the font and thus the textbox resizes to match it.
However, the sizes of the textboxes are important. Any ideas on how to stop the textboxes from changing size?
I'm considering just increasing the width/height of the textbox by ~15% after autosize chooses the appropriate size for the current zoom rate and then taking autosize off, but I'd rather not if possible, b/c I'd prefer the textbox to be a tight fit. Most importantly, I'm trying to make the printed output look best--but I don't know what zoom rate the print will be (I'm using Fit To Page on a selected Print Area).
As an example, here are the heights, widths of a given textbox at 100%, 400% and 25% zoom rates.
25% 66 105
100% 55.5 98.25
400% 54.75 94.5
I'm not sure yet, but perhaps changing the zoom rate changes the perceived size of the font and thus the textbox resizes to match it.
However, the sizes of the textboxes are important. Any ideas on how to stop the textboxes from changing size?
I'm considering just increasing the width/height of the textbox by ~15% after autosize chooses the appropriate size for the current zoom rate and then taking autosize off, but I'd rather not if possible, b/c I'd prefer the textbox to be a tight fit. Most importantly, I'm trying to make the printed output look best--but I don't know what zoom rate the print will be (I'm using Fit To Page on a selected Print Area).