Solved

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

Posted on 2014-02-03
7
292 Views
Last Modified: 2014-02-03
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
0
Comment
Question by:Nick Denny
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Author Comment

by:Nick Denny
ID: 39829383
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
 
LVL 14

Accepted Solution

by:
John-Charles-Herzberg earned 500 total points
ID: 39829387
It might be the font your are using.  It looks good on a MAC.  What font are you using?

Thanks
JC
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39829391
None of those issues viewing your file on my machine.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 13

Author Comment

by:Nick Denny
ID: 39829415
I have saved the file at 99.9%
Have you both tried setting back to 100%
Thanks
0
 
LVL 14

Expert Comment

by:John-Charles-Herzberg
ID: 39829423
Yes I have at 75%, 99% 100% and 150%

All look good.

Thanks
JC
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39829427
Same here.
0
 
LVL 13

Author Comment

by:Nick Denny
ID: 39829428
@JC - I think you've called it.
If I change the font, all the issues go away.
Very strange.
And good call.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question