ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dotted lines in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/141053-dotted-lines-excel.html)

Karl

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


Bill Ridgeway

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




Mike H

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


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