login about faq

To prove you're not a spammer, email newuser.lgqa@gmail.com with the subject "Account Request" to request an account.


I'm having an issue with Excel 2011 for Mac. I just bought a bunch of labels from onlinelabels.com, and their templates have a 0.125 spacing between each label. I can't get that space width or height to work in excel. How can I get this to work? Are there any work around? Any fixes? Any way possible for me to make this work? Please someone help me. This is so aggravating.

Thank you.

asked Mar 18 '11 at 10:13

moose205's gravatar image

moose205
1111


I am using Excel 2010 and got the rom and column to except the measurement just fine. Of course I'm using it on Windows 7 but that shouldn't matter. Make sure to adjust the rom height or column width that you highlight the entire element by clicking on the row or column header (the number or letter part). You can then right click on the number or letter and choose "Row height..." or "Column width..." and make you changes. Hope this helps.

answered Mar 18 '11 at 10:33

David's gravatar image

David
3.3k112062

I do that and it will only let me go to 0.12, or 0.13. There is no 0.### if that makes any sense. I'm wondering if this is a mac problem. Or is there a setting that I'm overlooking?

answered Mar 18 '11 at 10:35

moose205's gravatar image

moose205
1111

It's not Mac. I just went through all of the settings and there's nowhere to make that adjustment. Basically it is rounding the measurement you're typing in. I have looked everywhere I can think of in excel to turn off that option and I can't find it. I typed in 30.125 and it rounded up to 30.14. 30.12 also ='s 30.14. You're best option may be to enter 0.4 to get as close as possible. I can't even get it to let me enter 0.5. It auto corrects to 0.4.

(Mar 18 '11 at 11:08) David David's gravatar image

I was able to get it too 0.17 and that's it. The other option was 0.08.

(Mar 18 '11 at 11:09) David David's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported


Join Us in the Chat Room

Tags:

×79
×28
×21
×5

Asked: Mar 18 '11 at 10:13

Seen: 1,267 times

Last updated: Mar 18 '11 at 11:09