Mystery dotted line around certain rows in Excel 2007 worksheet

Occasional Contributor

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!



4 Replies
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.

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



best response confirmed by Scottisimo (Occasional 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.