Solved

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

Posted on 2014-02-03
7
287 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
Comment Utility
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
Comment Utility
It might be the font your are using.  It looks good on a MAC.  What font are you using?

Thanks
JC
0
 
LVL 26

Expert Comment

by:MacroShadow
Comment Utility
None of those issues viewing your file on my machine.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 13

Author Comment

by:Nick Denny
Comment Utility
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
Comment Utility
Yes I have at 75%, 99% 100% and 150%

All look good.

Thanks
JC
0
 
LVL 26

Expert Comment

by:MacroShadow
Comment Utility
Same here.
0
 
LVL 13

Author Comment

by:Nick Denny
Comment Utility
@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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now