Forum Discussion

Scottisimo's avatar
Scottisimo
Copper Contributor
Dec 04, 2021
Solved

Mystery dotted line around certain rows in Excel 2007 worksheet

Hi, my Excel 2007 worksheet has dotted lines around lines 9-32, and line 9 prints out at the top of every page.  I don't know how I did this, and would like to get rid of it.

 

Thanks in advance!

 

Scott

  • mtarler's avatar
    mtarler
    Dec 06, 2021
    Getting the Likes and Best Response scores. LOL, JK.
    I can't speak for others but for me, I came here to get help and was so thankful of the help and realized I could 'pay back' and help others. And honestly, I think I've learned more doing this than how much I've helped.

4 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    sounds like you set the print area. try going to page setup (page layout and hit little icon in bottom right) then go to Sheet. The first line is Print Area and second line is Rows to Repeat. Try clearing them.
    • Scottisimo's avatar
      Scottisimo
      Copper Contributor

      Thank you!!  I'm curious...  what motivates guys like you to help newbies likeme?

       

      mtarler 

      • mtarler's avatar
        mtarler
        Silver Contributor
        Getting the Likes and Best Response scores. LOL, JK.
        I can't speak for others but for me, I came here to get help and was so thankful of the help and realized I could 'pay back' and help others. And honestly, I think I've learned more doing this than how much I've helped.

Resources