Impossibly Tiny Text

[Bill Martin]

On rare occasions Excel 2003 (with all updates) screws up and will display
just one sheet with impossibly tiny text - like only one or two pels high on
the screen. All other sheets continue to look normal. All the cells appear
to still have correct information in them, it's just tiny.

I can select the entire sheet and tell it to use 100 point type and it will
produce type that looks like maybe 10 point type on the other sheets. Or I
can copy an entire good sheet, and "Paste Special" only the formats onto the
bad sheet and get back the impossibly tiny text again. Saving and reloading
the workbook doesn't help any.

To the best I can tell, this rare occurrence only happens when I've been
running VBA for an hour or so at the same time that the computer is doing
other things in the foreground. Excel will continue to look fine until the
VBA stops and kicks back to Excel, whereupon Excel displays the tiny text.

Does this sound familiar to anyone? Any suggestions?

Thanks.

Bill

 

[Gary''s Student]

Tiny, tiny text usually results from accidentally leaving the application in
PageBreak View with a large range.

 

[Beege]

On rare occasions Excel 2003 (with all updates) screws up and will display
just one sheet with impossibly tiny text - like only one or two pels high
on the screen. All other sheets continue to look normal. All the cells
appear to still have correct information in them, it's just tiny.

I can select the entire sheet and tell it to use 100 point type and it
will produce type that looks like maybe 10 point type on the other sheets.
Or I can copy an entire good sheet, and "Paste Special" only the formats
onto the bad sheet and get back the impossibly tiny text again. Saving
and reloading the workbook doesn't help any.

To the best I can tell, this rare occurrence only happens when I've been
running VBA for an hour or so at the same time that the computer is doing
other things in the foreground. Excel will continue to look fine until
the VBA stops and kicks back to Excel, whereupon Excel displays the tiny
text.

Does this sound familiar to anyone? Any suggestions?

Thanks.

Bill

Bill,

It's been my (limited) experience that your text isn't really tiny. You're
just in a zoom way out (10%?). Set your zoom to whatever your other sheets
are set .

Beege

 

[Bill Martin]

Bill,

It's been my (limited) experience that your text isn't really tiny. You're
just in a zoom way out (10%?). Set your zoom to whatever your other sheets
are set .

Beege

-----------------------------------------

You put your finger right on it. I've never noticed or played with the zoom
before, so I don't know how it get's changed but that one sheet was set to
10% rather than 100% like all the others.

Thanks.

Bill

 

[Jim Thomlinson]

Hold down the Ctrl key and scroll the wheel on your mouse. That will change
the zoom without touching the Zoom setting...