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
thx1139

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
thx1139

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
thx1139

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
Thread Forum
BSOD - Excel 2016 (MSO365) App Hang/App Error various error codes
Good Day, Been having an issue with Excel for a while. I have tried quite a few things that i would have thought could have fixed it, first tested it with a new machine (exactly the same spec as this machine) still did the same thing, reinstalled office on this machine and the other machine,...
BSOD Help and Support
drive label stuck as "OS Install" when no label is assigned
Hello, not sure if this is the correct area to ask, but I've noticed that my E drive's label is stuck as "OS Install" when there is no label assigned. I thought at first there was a label assigned to it and followed renaming labels option 3 on the forums (as a DVD drive was assigned to the letter)....
Performance & Maintenance
Excel-Word 2007 Label Merge
Hello I need to label 600 Minidv boxes with titles ranging from Tape #1 through Tape #600 Is there a way to do a label merge from Excel into Word 2007 (Label Avery 5167) ? Within Excel in column A I created a text range from Tape #1 down to Tape #600 I donít know how to export into Word that...
Microsoft Office
Error message when using Avery label template in Word 2010
:confused:I am trying to make Avery 5168 Labels but get this message: "The margins, label size, and number across or down values produce a page that is larger than the label page size." I'm not entering my own custom label sizes here - I'm selecting an Avery label from Word's own list. After...
Microsoft Office
SSD alignment - do i am done it right?
Hello, recently i bought 256Gb sandisk ssd, i wanted to clone my previous hard drive partition with Windows 7 in it, because i dont want to do any new installations of windows. there is just too much custom settings in system. Anyway, by reading tutorials over the net and using EaseUS partition...
Hardware & Devices


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 02:46.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App