Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel label alignment error


18 Feb 2014   #1

Win 7 Home Premium (OEM) - Install date: 02-2010
 
 
Excel label alignment error

Here I have a screenshot which should make clear what is expected to happen and what actually happens. For some reason Excel thinks that the datum in J114 corresponds to a label in A113 instead of A114 and so on. Anyone know how to get Excel back in line?




My System SpecsSystem Spec
.

19 Feb 2014   #2

Win 7 Home Premium (OEM) - Install date: 02-2010
 
 

Here are a couple of screenshots which I'm pretty sure demonstrate a bug in Excel. It functions fine when I put numbers in an additional column of labels and reverts to idiocy when I remove them:

Right:


Wrong:
My System SpecsSystem Spec
21 Feb 2014   #3

Win 7 Home Premium (OEM) - Install date: 02-2010
 
 

I've come to the conclusion that it isn't a bug. The labels are being moved to the first of each series of values and in order to get them to span the series, you have to create another column (containing e.g. spaces). This is a bit stupid but that's the way it is.
My System SpecsSystem Spec
.


Reply

 Excel label alignment error




Thread Tools



Similar help and support threads for2: Excel label alignment error
Thread Forum
Excel 2010 Script error popup when getting data from Web Microsoft Office
Excel - web queries - some ISP's get Script Error -- others work OK Microsoft Office
Error 557 + Audio Label software Software
Error when opening Excel or Word doc (Office 07) Microsoft Office
XML/Excel Error Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:50 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33