Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 114
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 268
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 114
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get rid of dotted lines of pagebreak view visible on Activesheet VJ[_2_] Excel Discussion (Misc queries) 1 March 29th 07 11:59 PM
In Excel03, I want wmf files to have dotted lines like in Excel00 loosecannon3 Excel Discussion (Misc queries) 0 March 6th 07 01:53 PM
To remove dotted lines in Microsoft Excel ? Mike Smithdorf Excel Discussion (Misc queries) 2 August 28th 06 08:54 PM
Print Preview Dotted Lines MCC-SusanC Excel Discussion (Misc queries) 1 August 7th 06 03:41 PM
Excel should improve dotted-line pattern. David Berry Charts and Charting in Excel 0 April 10th 06 05:25 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"