Cannot see data unless zoom is less than 100% plus column width problems

Hi Experts

I have just installed my Excel 2007 onto Windows 8.1 and am having some issues .
I have attached a pricelist workbook (single sheet).
On my machine I can only view info in the cells if the zoom is set to less than 100% (e.g. 99.9)
If I go back to 100% the data becomes invisible.
Also, if I do an autofit column width (select all cells and double click between the letters on the column letters) the columns are jumping to max width (255 pixels).
I have deleted all blank rows and all blank columns and then saved- same problem.
I have also done a "=len()" on each to ensure there is no extra characters.

I suppose it may just be a local issue on my machine but if I could get some feedback that would be great.

Many thanks

Nick
pricelist-issue.xlsx
LVL 13
Nick DennyAsked:
Who is Participating?
 
John-Charles-HerzbergCommented:
It might be the font your are using.  It looks good on a MAC.  What font are you using?

Thanks
JC
0
 
Nick DennyAuthor Commented:
Additional note on this - if I copy and paste onto a new workbook, I have the same problem.
However, if I copy and paste as values - the problem goes away......
Must be in the formatting ...????
0
 
MacroShadowCommented:
None of those issues viewing your file on my machine.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Nick DennyAuthor Commented:
I have saved the file at 99.9%
Have you both tried setting back to 100%
Thanks
0
 
John-Charles-HerzbergCommented:
Yes I have at 75%, 99% 100% and 150%

All look good.

Thanks
JC
0
 
MacroShadowCommented:
Same here.
0
 
Nick DennyAuthor Commented:
@JC - I think you've called it.
If I change the font, all the issues go away.
Very strange.
And good call.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.