First few characters in formula bar invisible

Drake Tungsten

New Member
Joined
Jan 16, 2008
Messages
3
A colleague of mine has run this problem past me, but I'm not able to help her - I've never seen this behavior before and don't know what sort of guidance to give.
In various files and over the course of at least the past few weeks, when checking on the contents of a cell in the formula bar, the first 5 or so characters are invisible to the user, i.e., the first part of the formula can't be read on the screen. The underlying formulas seem to function properly and if I copy and paste the entire formula to the another application (ex., notepad) I can then see the full formula.
What's happened here? And, how can I help her restore her copy of Excel to functioning properly again?
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,913
Office Version
  1. 365
Platform
  1. Windows
Welcome to the Board!

When you see really odd behavior like that, your best bet is probably to re-install Excel on that workstation, as it sounds like it might be a corruption issue.
 

excelandaccess

New Member
Joined
Oct 15, 2009
Messages
5
For me the problem was that my laptop display was thinking there were two monitors. I only have one monitor (the laptop screen). right click on the desktop and select properties. Then, click the settings tab. There are probably two monitors (1 & 2 square displayed). Click on the second plug n play (it may even say default), then go to advanced and disable that device.

I'm not sure why that connects to this Excel problem, but it fixed it for me.
(y)

I must give credit from this thread that helped guide me to the correct ballpark:
http://groups.google.co.uk/group/mi...cdb599f36f0?lnk=st&q=&rnum=1#37507cdb599f36f0
 

Watch MrExcel Video

Forum statistics

Threads
1,122,331
Messages
5,595,541
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top