+ Reply to Thread
Results 1 to 10 of 10

Dotted gray lines around cells in worksheet

  1. #1
    Registered User
    Join Date
    01-11-2010
    Location
    tracy, ca
    MS-Off Ver
    Excel 2003
    Posts
    39

    Dotted gray lines around cells in worksheet

    Hello,

    I'm working on a worksheet that another person started. For some reason there are dotted gray lines around every single cell in the print area in the print preview (no idea what this person did or who this person is, so I can't ask them). Anyhow, I need to get rid of these dotted gray lines. Clicking on no borders does not work. Anyone have any ideas? Thank you.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Dotted gray lines around cells in worksheet

    Hi,

    Do these grey lines appear in the final print?

    Does the workbook use macros which may be adding them?

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-11-2010
    Location
    tracy, ca
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Dotted gray lines around cells in worksheet

    Hi,

    Yes they do appear in the final print. I don't believe there are any macros associated with the worksheet.

    *edit: there are no macros

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Dotted gray lines around cells in worksheet

    Hi,

    Can you upload the workbook so we can take a look?

    Regards

  5. #5
    Registered User
    Join Date
    01-11-2010
    Location
    tracy, ca
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Dotted gray lines around cells in worksheet

    Sorry, cannot :/ Company confidential stuff. If I can't get rid of the lines I guess I'll live, but it would be nice to be able to get rid of them. It's not a dire need however.

  6. #6
    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: Dotted gray lines around cells in worksheet

    The data may be confidential, but the dotted lines aren't, right?

    Delete the data.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    01-11-2010
    Location
    tracy, ca
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Dotted gray lines around cells in worksheet

    True. Ok, here it is. Thanks.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-11-2010
    Location
    tracy, ca
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Dotted gray lines around cells in worksheet

    There are also some borders in there I forgot to remove. Pay no mind to those.

  9. #9
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Dotted gray lines around cells in worksheet

    File - Print setup - Sheet tab - untick "Gridlines"

  10. #10
    Registered User
    Join Date
    01-11-2010
    Location
    tracy, ca
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Dotted gray lines around cells in worksheet

    I figured it was something simple. Thanks a lot!

+ 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