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
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
error message when opening excel
After lots of problem I have just had my Windows7 professionally reinstalled and am now in the process of installing my software. The Microsoft Office software is Ms Office with Frontpage. My list of programs confirms that this is the installed program and Frontpage can indeed be opened. When I try...
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
SSD alignment
I have set up 2 computers with SSD as the C drive. I used diskpart to align both of them. Both had different issues. The 1st I could not install the image backup so I did a fresh install of W7. The 2nd the image restore when smooth and all seemed to work but I had a new hardware conflict the...
Hardware & Devices
SSD Alignment
Hi everyone, I have Intel X-25M 80 GB SSD. I want to install Windows 7 Pro x64, MS Office and other application on it. Should I create partition primary align=1024 or Create partition primary size=100 align=1024? Thank you.
Installation & Setup

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 07:13.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App