Computing.Net > Forums > Office Software > faulty prinout of excel spreadsheet

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

faulty prinout of excel spreadsheet

Reply to Message Icon

Name: Sebastian42
Date: July 26, 2007 at 03:06:32 Pacific
OS: WinXP
CPU/Ram: PIII/256Mb
Product: generic
Comment:

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



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: July 26, 2007 at 05:50:05 Pacific
Reply:

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 sheet

If 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 - Print

What 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.


0

Response Number 2
Name: Sebastian42
Date: July 26, 2007 at 21:49:44 Pacific
Reply:

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


0

Response Number 3
Name: DerbyDad03
Date: July 27, 2007 at 08:05:12 Pacific
Reply:

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.


0

Response Number 4
Name: Sebastian42
Date: July 29, 2007 at 05:48:54 Pacific
Reply:

"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


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Office Language Excel 2007 won't immediat...



Post Locked

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


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: faulty prinout of excel spreadsheet

Excel Spreadsheet Formula www.computing.net/answers/office/excel-spreadsheet-formula/9360.html

Linking to open excel spreadsheet www.computing.net/answers/office/linking-to-open-excel-spreadsheet/6074.html

Link Excel spreadsheet to Access? www.computing.net/answers/office/link-excel-spreadsheet-to-access/2411.html