+ Reply to Thread
Results 1 to 7 of 7

I have dotted lines showing on an excel document that I am not able to remove.

Hybrid View

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Windsor, Ontario
    MS-Off Ver
    excel 2007
    Posts
    18

    I have dotted lines showing on an excel document that I am not able to remove.

    I have an excel document (which I did not create) that has dotted lines on it used for people to write notes once it's been printed. I'm trying to delete every other line to give people more space when writing, but the lines won't delete. I've attached the document so you have a better idea what I'm talking about, thanks very much.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,708

    Re: I have dotted lines showing on an excel document that I am not able to remove.

    Select the cells you want to remove dotted lines from. Choose Format (keyboard shortcut Ctrl + 1). Choose Borders. Choose None. Choose OK.

    They cleared right out for me in the file provided.

    Does this do what you want?

    FR
    Last edited by FlameRetired; 09-05-2014 at 01:12 PM.

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    Windsor, Ontario
    MS-Off Ver
    excel 2007
    Posts
    18

    Re: I have dotted lines showing on an excel document that I am not able to remove.

    That worked, thanks very much.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,708

    Re: I have dotted lines showing on an excel document that I am not able to remove.

    Quote Originally Posted by FlameRetired View Post
    Select the cells you want to remove dotted lines from. Choose Format (keyboard shortcut Ctrl + 1). Choose Borders. Choose None. Choose OK.

    They cleared right out for me in the file provided.

    Does this do what you want?

    FR
    You're welcome.
    You'll mark [SOLVED]?

  5. #5
    Registered User
    Join Date
    10-29-2013
    Location
    Windsor, Ontario
    MS-Off Ver
    excel 2007
    Posts
    18

    Re: I have dotted lines showing on an excel document that I am not able to remove.

    I don't see anything that says solved.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: I have dotted lines showing on an excel document that I am not able to remove.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,708

    Re: I have dotted lines showing on an excel document that I am not able to remove.

    Quote Originally Posted by newdoverman View Post
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Thanks, newdoverman, and sorry nreed2929. I should have been clearer.
    FR
    Last edited by FlameRetired; 09-05-2014 at 06:12 PM.

+ 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. Dotted lines problem in Excel.
    By davidgriffith1234 in forum Excel General
    Replies: 3
    Last Post: 01-31-2013, 12:36 PM
  2. removing dotted lines in Excel 2010
    By Davidns in forum Excel General
    Replies: 7
    Last Post: 07-23-2012, 05:48 AM
  3. Remove dotted lines on spreadsheet
    By Vermilion in forum Excel General
    Replies: 5
    Last Post: 04-19-2012, 09:25 AM
  4. How to remove dotted lines around option buttons?
    By blipschu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2007, 07:05 AM
  5. Excel displays dotted lines.
    By kish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2006, 01:37 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