+ Reply to Thread
Results 1 to 3 of 3

Some gridlines missing - How to restore

  1. #1
    Oliver Costich
    Guest

    Some gridlines missing - How to restore

    I have some worksheets where some, but not all of the gridlines are
    missing. Using Tools/Options/View and unchecking and then checking
    makes no difference. Any solution? I'd like to have them.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475
    have you been playing with conditional formatting?
    or

    Maybe you filled the cells in as white, try highliting the sheet and select no fill

  3. #3
    CraiginNJ
    Guest

    Re: Some gridlines missing - How to restore

    FYI - At my office my boss often filled cells of his summaries with
    white, thinking it looked better when he pasted it into .ppt's. This
    drove me nuts because I couldn't figure out what he did.

    (I prefer to see the gridlines, and I know that they disappear on
    printouts and in metafile pastes into .ppt's unless borders were used.
    What's more, he tended to color cells way out in the unused hinterlands
    of the .xls., so scrolling to the outer edges went all the way out to
    there instead of stopping with the cells that had contents.)

    I hunted through the view options for gridlines (was set to visible)
    and played with various colors of gridlines and background cell colors,
    and tried other suggestions on this newgroup. Finally I got my boss to
    tell me what he did. The good news is that it is easily reversable.

    Good luck,

    Craig in NJ


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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