LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 03' columns don't line up after pg 10 when printing/previewi

In Excel 2003, I have a worksheet with roughly 135 columns that spans 13
pages when printed. I've anticipated that a max of 24 rows might be inserted
and have added a border for all cells across the entire 24 rows x 135 columns
(i.e. each indiv cell has a border on all sides). There are various width
column headings in each cell in row 1 that are bolded and slanted at a 65
degree orientation. The text in the column headings is arial 10pt and I have
the 'wrap text' feature turned on. The height for row one is 99.75. All
other rows are the default height.

When I use the print preview option or actually print the worksheet, the
first 9 pages print exactly as I would expect. However, from page 10 thru
13, the column heading no longer line up with the rows below them if you look
at the lines for the cell borders between rows 1 and 2. I've also noticed
that some columns are not being printed at all and others are being repeated
from one page to the next.

My assumption is that the problem is related to the orientation of the data
in row one because if I change row one to be the default orientation of 90
degrees, everything prints fine. I've tried varying the oriention from 65
degrees up to 89 degrees but the problem still appears. Only when I reset
the orientation back to 90 degrees does it resolve the problem.

Does anyone have a suggestion on how to retain the use of the 65 degree
orientation yet resolve the issue with the columns not lining up?

Any help you can throw my way would be greatly appreciated.
 
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
How do I freeze a line in an Excel graph when printing 3PL Bill Excel Discussion (Misc queries) 1 April 23rd 08 12:57 PM
Printing on columns in excel ionut007 Excel Discussion (Misc queries) 2 October 2nd 07 06:24 PM
counting line by line matches of 2 columns possible in excel ? Medikto D Excel Discussion (Misc queries) 3 June 1st 06 05:46 PM
Excel: printing with hiddent columns MLE Excel Discussion (Misc queries) 0 October 25th 05 09:01 PM
Excel: printing with hiddent columns MLE Excel Discussion (Misc queries) 0 October 25th 05 09:01 PM


All times are GMT +1. The time now is 04:09 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"