+ Reply to Thread
Results 1 to 12 of 12

What is White Space and Why is it Doing This?

  1. #1
    Registered User
    Join Date
    08-08-2016
    Location
    Oregon
    MS-Off Ver
    Office 365 for business
    Posts
    5

    What is White Space and Why is it Doing This?

    http://i48.photobucket.com/albums/f2...l%20issues.png
    http://i48.photobucket.com/albums/f2...es%20click.png

    Ok, I am having issues posting pictures... Less than ideal but I suppose this will work.

    What in the heck is going on here (see pictures) ladies and gentlemen?

    I fancy myself a bit of a google master, narrowing concerns down to the important words and getting results! Ok, well for my first post I should ensure that no one actually believes I am a master of anything, especially The Google. Having said that as you may see in the picture, I cannot even put into words what is going on here so attempts at finding solutions, both on the forum and on The Google have proven futile.

    What I can add, as seen in one of the pictures, where the mouse was for the screen shot it says "show white space", if you click on that area you get the other image I posted and hovering over the "white space" gives the note "hide white space". The only other thing I can add is the last time I used the computer I installed DYMO labelwriter software. I did notice there was a DYMO add-on loading as Excel booted, and the new boxes look oddly like label squares. I disabled the add-on and when that didn't change anything I deleted the software... that didn't change anything either. These spreadsheets are for purchase requests so I have 6 or 7 I have submitted over the last week, I save them all to my personal one drive after sending off to the front office and ALL of them are doing this now... meanwhile I have some other spreadsheets I made that do not have issues like this.

    This is on my work computer that was just wiped a few weeks ago and windows 10 installed. I am a teacher so the computer has had minimal use since I did the wipe and upgrade to windows 10. I have installed a copy of the entire office 365 suite on my computer and have had no issues until today. The goober in me is ready to delete the Microsoft suite and reinstall, but it is so much work and time to get all of my outlook, one drive and one note accounts set back up and logged in for an issue that may happen again and/or may not be resolved.

    Any help or suggestions are Truly appreciated, Thank you!

    -Andrew Long
    Attached Images Attached Images
    Last edited by andrew.long; 08-08-2016 at 08:03 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: What is White Space and Why is it Doing This?

    Hi, welcome to the forum

    Ok, I am having issues posting pictures... Less than ideal but I suppose this will work.
    No sorry, not really

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-08-2016
    Location
    Oregon
    MS-Off Ver
    Office 365 for business
    Posts
    5

    Re: What is White Space and Why is it Doing This?

    Let me attempt to clarify... Maybe I am the one who still needs clarifying.

    I am not looking for any expected results other than the white lines that are clearly some type of weird formatting running through my purchase request template (and all others made before today that worked fine when I created them but now have the same weird formatting issue as my original. I use the posted spreadsheet to send to the secretary at my school to authorize purchases... the spreadsheet design is quite simple and multiplies the quantity and the cost per item then adds these totals for an overall total. As of today I opened up my original to prepare another purchase request and I see what I have pictured (I understand that many may have difficulty seeing my pictures). Posting the spreadsheet will not be helpful because opening them on my surface provides me a fully functional spreadsheet with none of my formatting concerns I am trying to resolve. So it is an issue with Excel on my desktop. I tried to upload pictures, apparently I have them uploaded to the website but clicking on the attachment button pops up an empty box.

    I post here because I figured someone who knows the program far better than me (most of the world and everyone on here) may know what settings were changed to cause this issue with my spreadsheet.

    Thank you for the welcome, if there is any better information I can furnish, please ask!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: What is White Space and Why is it Doing This?

    Like I said, not all members can even see the pics you posted, plus, we cannot see from a pic, what might be causing the problem.

    Van you upload a small (clean) sample?

  5. #5
    Registered User
    Join Date
    07-26-2016
    Location
    Torun, Poland
    MS-Off Ver
    2007/2010/2013
    Posts
    23

    Re: What is White Space and Why is it Doing This?

    I also don't understand fully what your problem is, but I think the issue might be a page break settings. Go to Page Break Preview (its the small icon on the lower right part, near zoom bar). There should be vertical, thick lines, or dotted lines in the middle of sheet witch you can move by mouse. Move them to the right side, to make them dissapear. Then switch back to page layout view (the middle icon) and see if it works
    Liked my solution? Please, click "Add Reputation".

  6. #6
    Registered User
    Join Date
    08-08-2016
    Location
    Oregon
    MS-Off Ver
    Office 365 for business
    Posts
    5

    Re: What is White Space and Why is it Doing This?

    Thank you Fdibbins for your time on this, Feronen, I also appreciate your time.

    I would love to give an iron clad solution to this but I let my computer sit and think about what it was doing last night and it decided to work just fine today. (I didn't reset it or anything). I would lean towards Feronen's suggestion. I did go to the page break preview and it was WILDLY different than what I am getting today, like each box that formatted itself in was a separate page. I am curious if it was the labelwriter software that screwed it up, it would make sense that it would page break in the approximate size of my labels I have loaded.

    Anyway, All is well and I appreciate the time both of you had into attempting to help me! +rep!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,247

    Re: What is White Space and Why is it Doing This?

    Im happy you got it resolved, wish we could have been more help . Thanks for the feedback

  8. #8
    Registered User
    Join Date
    08-08-2016
    Location
    Oregon
    MS-Off Ver
    Office 365 for business
    Posts
    5

    Re: What is White Space and Why is it Doing This?

    One last time then I will let this die. It was the DYMO software. I reinstalled it and my spreadsheet went to hell again.

    Oh well. This time I will just disable the dymo add-on and be patient.

    Thanks again!

  9. #9
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: What is White Space and Why is it Doing This?

    I've had DYMO Label v.8 installed on W7 for years without difficulty (love my LabelWriter, but the software sucks). It's not being set as your default printer, is it?
    Entia non sunt multiplicanda sine necessitate

  10. #10
    Registered User
    Join Date
    08-08-2016
    Location
    Oregon
    MS-Off Ver
    Office 365 for business
    Posts
    5

    Re: What is White Space and Why is it Doing This?

    VICTORY! Hahaha. That was it! Between trying to search, creating and following up on this post. I probably have 2 hours trying to figure out what the heck was going on. Set my actual printer to the default and the crazy formatting went away! +rep!!!

  11. #11
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: What is White Space and Why is it Doing This?

    You're welcome.

  12. #12
    Registered User
    Join Date
    07-26-2016
    Location
    Torun, Poland
    MS-Off Ver
    2007/2010/2013
    Posts
    23

    Re: What is White Space and Why is it Doing This?

    Thanks for feedback, I am happy to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. White Space at begining of a number
    By Sweetmand in forum Excel General
    Replies: 13
    Last Post: 02-16-2015, 08:57 AM
  2. Add white space above and below cells
    By Getfothers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2013, 02:05 AM
  3. white space
    By forumexcel in forum Excel General
    Replies: 2
    Last Post: 03-16-2012, 05:15 PM
  4. Help with white space
    By komet12 in forum Excel General
    Replies: 3
    Last Post: 10-26-2009, 04:59 PM
  5. White Space in a Cell
    By Gina O'Brien in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-17-2005, 10:05 AM
  6. Extra white space between cells
    By Leesa in forum Excel General
    Replies: 1
    Last Post: 05-24-2005, 07:20 PM
  7. [SOLVED] White Space in PDF from Excel
    By Antony in forum Excel General
    Replies: 0
    Last Post: 05-23-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1