+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Gridlines turned on but do not show

  1. #1
    Registered User
    Join Date
    07-21-2011
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Gridlines turned on but do not show

    Occasionally I receive an excel sheet that does not show any gridlines. I have tried going into view and making sure that show gridlines is selected. I’ve also tried selecting hide gridlines and then reselecting show gridlines to no avail. Finally I went to Excel options and made sure show gridlines was selected under advanced settings.
    The only thing I’ve been able to do is add borders (which I don’t like the look of) or set up a new tab and bring the data over using formulas, then cut and paste values only. If I just copy the non-gridline data, I get a copy without gridlines. I’m sure there must be some easy trick to this – I just don’t know how the spreadsheet author got the gridlines to disappear.

    Thanks in advance for any help.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Gridlines turned on but do not show

    Hi,

    Can you provide a sample showing this problem?

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Gridlines turned on but do not show

    What colour is set for these grid lines?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    07-21-2011
    Location
    Red Bank, NJ
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Gridlines turned on but do not show

    Color is set to Black and I also checked that Patterns is set to automatic. I've tried to upload a sample.
    Attached Files Attached Files

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

    Re: Gridlines turned on but do not show

    The cells are filled white. Set them to no fill to see the gridlines.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    05-23-2013
    Location
    Bhopal, Madhya Pradesh
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Re: Excel 2007 : Gridlines turned on but do not show despite setting their color.

    A blank sheet would not show gridlines even after setting gridlie color. One has to put some data atleast in on one of the cells. Then, gridlines will appear instantaneously

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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