Excel - Screen size fault? - Urgent please

[ajw150]

Hi,

I have designed a set template on worksheets which runs through th
whole workbook. When I run it as 100% zoom on my screen, its fine bu
on some PC's it is enlarged and only half the template fits on.

Is this an Excel issue, or could it be the display settings on th
monitor? I would check but can't get to it due to admin controls.

Thanks

Andre

 

[Dave Peterson]

It sounds like a display setting difference to me.

I use 1024x768 on my 17" monitor.

At work, I use 1280x1024 (19" monitor).

There are some people who use 640x480--to make the display really large.

You might be better off designing your form for the worse case.

Or maybe you could zoom to just show the columns you want.
Select A1:M1 (or whatever you want)
then click on the zoom dropdown and change it selection.

Then try it on the problem pc's. If it works ok, you could have a macro that
does it each time the workbook opens.