Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Problelm with some sheets not printing the borders (lines).

I have a workbook with several sheets that are formated the same. My problem
is some of the sheets do not print the underline borders that are on the
page, which also display when you go into print preview. Margins are set the
same on the sheets and so are the column widths.

How can I fix the problem to get the sheet to print with the borders?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Problelm with some sheets not printing the borders (lines).

Lets say that your print area is A1:J10 and you want to have a border line
to appear beneath row 10 when printed. There are two ways to do it. You
can select A11:J11 and add a top border line. Or you can select A10:J10 and
add a bottom border line. It looks the same on screen. But it doesn't
print the same. Since the print range ends at row 10 the border applied to
the top of row 11 is not in it.

So, remove your non-printing borders, and then add a bottom border selecting
the last row actually in your print area.

--
Jim
"grover finance" <grover wrote in message
...
|I have a workbook with several sheets that are formated the same. My
problem
| is some of the sheets do not print the underline borders that are on the
| page, which also display when you go into print preview. Margins are set
the
| same on the sheets and so are the column widths.
|
| How can I fix the problem to get the sheet to print with the borders?


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
Excel- printing borders (not grid lines) Don Excel Discussion (Misc queries) 0 May 1st 08 07:38 PM
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
Printing with grid lines or borders - problem AnnZ Excel Discussion (Misc queries) 2 May 30th 07 10:36 PM
Removing lines and/or borders mystical_ways Excel Discussion (Misc queries) 1 August 9th 05 07:35 PM
HOW DO I ADD LINES AND BORDERS IN ASPREADSHEET RUDY Excel Discussion (Misc queries) 1 March 2nd 05 11:33 AM


All times are GMT +1. The time now is 05:31 PM.

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"