Cell Spacing Problem

K

KJM3

Hi All,

I'm having a problem with a file that's used around our office fo
record keeping. On everyone else's computer (running Win2K and Offic
2000), the file fits on one page and looks fine when printed. O
another computer (running WinXP and Office 2000) it also looks/print
fine.

This brings me to my computer (IBM Thinkpad T41) running (WinXP).
Originally I installed Office 2003 and when I opened the file tha
everyone else used, it no longer fit on 1 page. I double checked th
margins and column widths and they were all the same. But visuall
speaking, it was obvious that my columns were wider. The gap betwee
the last letter in the column and the end of the column is about 1c
longer on my computer than everyone else's.

i.e. if Column A is 30.89mm wide on both my computer and everyon
else's computer, it will look wider on mine:

Column A | <===How theirs looks (indicated at 30.89mm wide)
Column A | <===How mine looks (indicated at 30.89mm wide)

As a result of this, I figured it was an Office 2003 problem, so
uninstalled Office 2003 and reinstalled Office 2000 (without restartin
in between). Alas, Office 2000 exhibited the same behavior. So,
tried uninstalling Office 2000 and reinstalling it. Problem stil
there.

So I figured that me not restarting my computer between Uninstallin
Office 2003 and installing Office 2000 may have caused a problem wit
registry entries not being deleted.

So as a last ditch effort, I uninstalled Office 2000 and restarted an
then reinstalled Office 2003 and restarted, and then uninstalled Offic
2003 and restarted and FINALLY I installed Office 2000 again. To m
dismay, the problem is still there.

Any suggestions? Any help would be appreciated! I'm desperate!

Thanks,
K
 
H

Hans

Hi

Doesnt it have something to do with your computer screen
setup? Try Settings, Control Panel, Display, tab Settings
and check if you have the same settings as on other
computers.

Im not sure if it will make a difference - just an idea...

regards
Hans
 
S

Stephen Bye

My guess is that you have a different screen resolution, and/or you do not
have the same set of fonts installed on your computer as they have on
theirs, or you have a different 'system' font, which is what the column
width is a multiple of.
 
K

KJM3

Hey guys, thanks for the input!

How would I go about changing the "system" font to the same one used o
other computers? The reason I'm asking is that I already know that th
font on the spreadsheet is the same on both computer (Arial 10), so th
'system' font suggestion makes lots of sense!

I tried the same file on both my HOME computers and they both look lik
my notebook.

It seems I may have a newer font that the older computers (at work
don't have as the system font.

Thanks,
KJ
 
K

KJM3

My problem isn't so much what it looks like on screen, but the fact tha
when I print it, it no longer fits on one page. (I noticed that o
other computers with the same resolution as mine, it looks fine o
screen and prints fine as well). I figured no matter what I changed m
resolution to, it would print the same way regardless? Am I mistaken?
:(

Thanks,
KJ
 
K

KJM3

UPDATE:

I checked the "font substitutes" in the registry and all the fonts wer
the same value (including the 'system font'). I don't know what to d
now!

I'm at a loss! Any other ideas?

- K
 
S

Stephen Bye

1) Are you using the same screen resolution as on the other computers? The
actual column widths are a specified number of characters plus a few pixels
for space either side of the cell contents and the gridline. If you are
using a different screen resolution then the pixels will be a different
width.
2) Get a ruler and measure the column widths on your system and on the
others, to see if it is really the column that is wider or the text that is
shorter. If the column is wider then you need to see what is specified as
the 'standard' font (see the Excel help text topic "Change column width").
If the columns are the same size but the text is smaller then see which font
is being used for the cell text. Check that you actually have a font file
for this font in your system fonts folder (if you don't then Windows will be
substituting a different font), and that it is the same file as is in use on
the ther systems.
 
K

KJM3

Hi Stephen,

My problem centers around the fact that when I print, it no longer fit
on one page. No matter what I've changed the screen resolution to, th
print preview still looks the same. Mine has more "white" spac
between either side of the cell contents and the gridline. As
result, my printouts go onto 2 pages instead of 1. I've even trie
putting other printers onto my computer, but the problem is the same.

It's not really MY computer's problem as other computers I've sent th
file to (at different companies) all say it prints onto 2 pages.
Unfortunately, 5 other people in my office use these files so I have t
change my computer to fit the spreadsheet (I can't ask 5 other's to fi
the problem).

On the printout, I can see that my printouts have wider and talle
columns than the other people's printouts.

Also, both fonts are "Arial 10" which shouldn't be a problem. I eve
checked the registry for "FontSubstitute" and we have the same fon
codes etc.

I'm so stumped, but I can't work on this file at my own computer until
I resolve this. So far, I've been working on OTHER people'
computers!!!

But as always, your advice is very much appreciated!

Thanks,
KJ
 
S

Stephen Bye

Okay, then go to File > Page Setup and check the box to fit the output to 1
pages wide by 1 pages tall; does that fix it?
 
Top