Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
Name: Sebastian42
One sheet of an excel workbook that prints quite well from Excel97 through an Epson Stylus Color II printer, has the cell contents misaligned to the grid, when printed from Excel2K through a HP Laserjet.
Another spreadsheet in that workbook prints equally well from both systems.
In another attempt from a freshly started spreadsheet, NO grids printed at all !
What can I tweak to fix this ?Basty

First, let's make sure we are talking about gridlines and not borders. Those are 2 very different things. I'll assume we are talking about gridlines and take a shot at this.
re: In another attempt from a freshly started spreadsheet, NO grids printed at all!
You don't say which combination presented this problem. (97/Epson or 2K/HP) In any case, I believe the option to print gridlines in Print Set-up...Sheet is un-selected by default, so it must be selected in each "freshly started spreadsheet". Did you select that option?
As far as the original not printing gridlines with 2K/HP, and again assuming we are talking about gridlines not borders, try this in 2K/HP first:
1 - Unselect the print gridlines option in Page Setup...Sheet.
2 - Print the sheet
3 - Turn the option back on.
4 - Print the sheetIf that doesn't help try this:
1 - Turn the option off in 97/Epson
2 - Save the file
3 - Open the file in 2K/HP
4 - Turn the option on
5 - PrintWhat I'm trying to do in both cases is to attempt to clear any remnants of the Epson print driver from the file that may be hanging around when you open it under 2K. I don't know if any of this will help, but it's worth a shot.

Sorry for the spelling mistake... careless !
I've done a lot of experimenting since, so can now cast the problem in a different light.
The SS which printed corectly was Landscape
format. If for the sake of experimenting, I print it as Portrait, THAT SS also becomes misaligned.The problem occurs in XL2K/HPLaser combination.
XL97/Epson is fine for both Landscape and Portrait.
The SS about which I complained is (and has to be) Portrait.
Basty

It's hard to tell from this distance what's happening. I'd ask you to send me the spreadsheet, but I'm going off-line (into the woods) for the next 3 days.
One last thing to try - look at both the horizontal and vertical algnment of the cells. Format..Cells...Alignment. Perhaps you can fix it that way.

"One last thing to try - look at both the horizontal and vertical algnment of the cells. Format..Cells...Alignment. Perhaps you can fix it that way." Nothing useful presented itself. Thanks anyway.
Basty

![]() |
Office Language
|
Excel 2007 won't immediat...
|

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |