Gridlines print over cell contents
Gridlines print over cell contents
(OP)
When I print some, but not all, Excel files the row gridlines get out of sync with the row contents so that halfway down the page the gridlines are running thru the row text. This is using page setup-sheet-gridlines. This does not show up on print preview. It happens regardless of which printer in the office I use.
It does not happen when another computer prints the same file.
Anybody know where the magic switch to fix this problem is?
It does not happen when another computer prints the same file.
Anybody know where the magic switch to fix this problem is?





RE: Gridlines print over cell contents
You have two choices:
> Turn on word wrap on the Alignment tab in Format
> Merge the cells you're overlapping with text to the cell containing the text
TTFN
RE: Gridlines print over cell contents
TTFN
RE: Gridlines print over cell contents
RE: Gridlines print over cell contents
TTFN
RE: Gridlines print over cell contents
how about disabling the print gridlines feature...
from main menu; file-page setup, select sheet tab and ensure print gridlines checkbox is not checked.
good luck!
-pmover
RE: Gridlines print over cell contents
Maybe this is a file corruption issue.
RE: Gridlines print over cell contents
Take a look at your row height settings where the grid starts going through the text. Look at the cells around where the change occurs. Do you have some special characters inbedded inside of a cell. There may be a cell trying to print printer control characters thus changing the printer settings.
RE: Gridlines print over cell contents
Could it be that the printer driver is configured to use these printer fonts? If this is true, maybe you can set it to "send all fonts as grafics" (or similar) ?
Btw pls excuse my English, I come from Germany
Michael Marx
Electrical and Control Engineer
VOITH Paper - Euskirchen, Germany
RE: Gridlines print over cell contents
We have networked computers going to network printers. This problem is isolated to a few computers printing some, but not all files.
I now find I can print a spread sheet on 11 x 17 paper OK but when I print to 8 1/2 x 11 paper the row grid lines print over the rows.
RE: Gridlines print over cell contents
Despite what your IT guys might say, keep pressing them. Often, they do things that they think will have no effect, yet can often create odd symptoms. We've havd problems with a double-sided capable printer that would suddenly stop printing double-sided or would suddenly have the double-sided option turned off. In both cases, continual nagging would invariable result in, "Oh yeah, I had to change something..."
TTFN
RE: Gridlines print over cell contents
A file I made on this computer months ago printed OK on printer #1 then and prints OK on printer #1 today.
A file I just made on this same computer does not print OK on printer #1 today. Viewing on Print Preview, using 8 1/2 x 11 paper and row and column headings showing, I see a page with 51 rows and 51 lines of text each centered in a row. Great. But when the page prints there are 51 lines of text printed in 50 rows with the row lines gradually striking thru the text until at the bottom of the page the 51st row is empty.
If I print this same page on 11 x 17 the landscape way, the 51 lines of text print inside the 51 rows. Well there is a slight shift up - the text is centered in line 1 but by line 51 the text looks like it is aligned with the top of the row.
We think we have downloaded the latest HP printer drivers. But does this sound like a computer (file) problem or printer problem?
Thanks in advance.
RE: Gridlines print over cell contents
Did any changes occur on the computer in the intervening months between when the file that does work was created and now?
Can you "Save As" the working file into a new file and does it work?
TTFN
RE: Gridlines print over cell contents
We get a number of "odd" problems in various software apps which seem to defy logic. My most frequent approach is to assume that the computer in question is suffering from either memory leakage or hard disk overload.
In the m-l scenario, everything you did today leaves something in RAM which eventually clogs up and causes an interference at a critical address, which shows up in either the screen redraw or the printer buffer (which are probably low in the useage heierarchy.
In the h-d-o scenario, all the temporary files which you write to the hd every time you flip out of a screen or window, eventually interfere with the processor's ability to find a big enough contiguous block to reserve for the next command, which again may be a screen redraw or print spooling.
In the majority of cases the rule is "save frequently and always be prepared to reboot". That way you will avoid, or at least work out of many of the sillier problems.
When we find something which, reliably will not work on one computer but will work on another, upgrading the first to the memory size of the second is the most likely solution.
You can get downloadable memory managers like RAMIdle which will handle the day to day chores of cleaning out the memory leakage but they too sometimes cause the problem (due to address interferences?)
We have also had printing problems which cropped up on the way to a network plotter because of some sort of incompatibilities with the spooling capacity of the computer, the intermediate server, the router and the plotter. We solved that by hard coupling the computer to the plotter for those files which didn't make it properly.
Funny things computers!!
Good luck
David