![]() |
Dotted lines in Excel
Hi,
In Excel 2003 Ive created a spreadsheet that tracks my departments jobs, job numbers, profits and so on. It all works fine, except that for obvious reason dotted lines have appeared that bisect the page horizontally and vertically. I didnt put them there and Id like to get rid of them. Ive tried changing the formatting; that doesnt work. Ive tried deleting that cells on either side of the dotted line; the line simply reappears in the same relative position as before. Can anyone tell me whats going on, and how to fix it? Any and all help much appreciated. Karl |
Dotted lines in Excel
Those dotted line mark the page boundaries. You can get rid of them by
clicking on <View<Normal. Regards. Bill Ridgeway Computer Solutions "Karl" wrote in message ... Hi, In Excel 2003 I've created a spreadsheet that tracks my department's jobs, job numbers, profits and so on. It all works fine, except that for obvious reason dotted lines have appeared that bisect the page horizontally and vertically. I didn't put them there and I'd like to get rid of them. I've tried changing the formatting; that doesn't work. I've tried deleting that cells on either side of the dotted line; the line simply reappears in the same relative position as before. Can anyone tell me what's going on, and how to fix it? Any and all help much appreciated. Karl |
Dotted lines in Excel
I suspect they represent the page breaks.
To get rid of them (2003) Tools - Options -View uncheck page breaks Mike "Karl" wrote: Hi, In Excel 2003 Ive created a spreadsheet that tracks my departments jobs, job numbers, profits and so on. It all works fine, except that for obvious reason dotted lines have appeared that bisect the page horizontally and vertically. I didnt put them there and Id like to get rid of them. Ive tried changing the formatting; that doesnt work. Ive tried deleting that cells on either side of the dotted line; the line simply reappears in the same relative position as before. Can anyone tell me whats going on, and how to fix it? Any and all help much appreciated. Karl |
Dotted lines in Excel
Mike, Bill,
That fixed it. Thank you both very much. Karl "Karl" wrote: Hi, In Excel 2003 Ive created a spreadsheet that tracks my departments jobs, job numbers, profits and so on. It all works fine, except that for obvious reason dotted lines have appeared that bisect the page horizontally and vertically. I didnt put them there and Id like to get rid of them. Ive tried changing the formatting; that doesnt work. Ive tried deleting that cells on either side of the dotted line; the line simply reappears in the same relative position as before. Can anyone tell me whats going on, and how to fix it? Any and all help much appreciated. Karl |
All times are GMT +1. The time now is 08:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com