Proportional fonts....

J

Joe Kania

Hi all,

We have columns in a lot of spreadsheets that have 7 digit
SKU numbers. The initial spreadsheet, at 100%, with a
Courier font, looks great (all numbers are lined up
correctly). If I change the sheet to 75% to look at more
data at once, the font changes and the alignment becomes
off.

It is repeatable on everysystem I have been to. I have
changed printers, fonts, etc. no matter what font I
choose I get the same results.

Any gueses?

TIA,

Joe Kania
ShopKo Stores, Inc.
 
D

David McRitchie

Okay I see what you mean checked it at 75%. I was actually
thinking of printing on paper -- "fit to page" but am surprised
that the display does not
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Joe Kania said:
I tested with both Courier New and Lucinga Console and get
the same result:

100% - Fine
200% - Fine
80% - Fine
79% and below - Left side is misaligned
Click to expand...
9865214523
3985210236
9521102141
3985421458
9865322114
 
G

GB

Forgive me butting in here but I have just done this in Excel 97 and it all
looks perfect over here! HTH


David McRitchie said:
Okay I see what you mean checked it at 75%. I was actually
thinking of printing on paper -- "fit to page" but am surprised
that the display does not
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I tested with both Courier New and Lucinga Console and get
the same result:

100% - Fine
200% - Fine
80% - Fine
79% and below - Left side is misaligned
Click to expand...
9865214523
3985210236
9521102141
3985421458
9865322114
Click to expand...
 
D

Debra Dalgleish

You can change a registry setting, as described in the following MSKB
article, to prevent this from happening. It's a fix for the Euro symbol
display problem, and also fixes the proportional font display.

Make a backup copy of the registry first:

XL97: Euro Currency Character Is Not Displayed Correctly
http://support.microsoft.com/default.aspx?id=192361
 
D

David McRitchie

What pointsize, fails at 10 works at 12 points for me with
Lucida Console with zoom at 75%

My system is Windows 2000 and the Excel is 2000 as well.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

GB said:
Forgive me butting in here but I have just done this in Excel 97 and it all
looks perfect over here! HTH


David McRitchie said:
Okay I see what you mean checked it at 75%. I was actually
thinking of printing on paper -- "fit to page" but am surprised
that the display does not
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I tested with both Courier New and Lucinga Console and get
the same result:

100% - Fine
200% - Fine
80% - Fine
79% and below - Left side is misaligned
Click to expand...
9865214523
3985210236
9521102141
3985421458
9865322114
Click to expand...
Click to expand...
 
Top