#1   Report Post  
Old October 8th 09, 08:20 PM posted to microsoft.public.excel.misc
LSG LSG is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 16
Default dashes around cells

working w/sprdsht w/363 lines; when I go to print it says 174 pages, even
after setting print area. From lines 59-363 the cells have dashes around
them, but lines 1-58 do not have dashes. I did go into to format cells and
tried to fix the cells with the border format, but it is a "no go". I am not
sure what happened; can anyone help to get the dashes from around the cells?
Thx.

  #2   Report Post  
Old October 8th 09, 08:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default dashes around cells

Have you tried selecting all the cells, then removing page breaks.

In xl2003 menus:
Insert|Reset all page breaks

lsg wrote:

working w/sprdsht w/363 lines; when I go to print it says 174 pages, even
after setting print area. From lines 59-363 the cells have dashes around
them, but lines 1-58 do not have dashes. I did go into to format cells and
tried to fix the cells with the border format, but it is a "no go". I am not
sure what happened; can anyone help to get the dashes from around the cells?
Thx.


--

Dave Peterson
  #3   Report Post  
Old October 8th 09, 08:49 PM posted to microsoft.public.excel.misc
LSG LSG is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 16
Default dashes around cells

I did try that but it did not work...Thanks.

However, I found the error: it was in the Page Setup, Rows to repeat at top
that made the worksheet have so many pages. Once the rows to repeat was
cleared, the worksheet reduced to seven pages!

Thank you for your reponse Dave...

"Dave Peterson" wrote:

Have you tried selecting all the cells, then removing page breaks.

In xl2003 menus:
Insert|Reset all page breaks

lsg wrote:

working w/sprdsht w/363 lines; when I go to print it says 174 pages, even
after setting print area. From lines 59-363 the cells have dashes around
them, but lines 1-58 do not have dashes. I did go into to format cells and
tried to fix the cells with the border format, but it is a "no go". I am not
sure what happened; can anyone help to get the dashes from around the cells?
Thx.


--

Dave Peterson

  #4   Report Post  
Old October 8th 09, 11:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default dashes around cells

Thanks for posting back with your solution.

I would have never guessed that.

lsg wrote:

I did try that but it did not work...Thanks.

However, I found the error: it was in the Page Setup, Rows to repeat at top
that made the worksheet have so many pages. Once the rows to repeat was
cleared, the worksheet reduced to seven pages!

Thank you for your reponse Dave...

"Dave Peterson" wrote:

Have you tried selecting all the cells, then removing page breaks.

In xl2003 menus:
Insert|Reset all page breaks

lsg wrote:

working w/sprdsht w/363 lines; when I go to print it says 174 pages, even
after setting print area. From lines 59-363 the cells have dashes around
them, but lines 1-58 do not have dashes. I did go into to format cells and
tried to fix the cells with the border format, but it is a "no go". I am not
sure what happened; can anyone help to get the dashes from around the cells?
Thx.


--

Dave Peterson


--

Dave Peterson


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
Dashes I want Dashes Marilyn Excel Discussion (Misc queries) 3 January 4th 08 12:32 AM
What are dashes for WLMPilot Excel Discussion (Misc queries) 3 November 28th 06 12:03 AM
Dashes in Functions LPS Excel Discussion (Misc queries) 2 January 19th 06 03:38 PM
format cells not to except dashes kclover Excel Discussion (Misc queries) 2 November 29th 05 06:26 PM
using dashes and the arrow key cyndi Excel Discussion (Misc queries) 1 February 2nd 05 10:53 PM


All times are GMT +1. The time now is 01:57 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017