close

I'm at my wits end! There is this cell in my spreadsheet that won't print (on
paper). Everything else around it prints. I've tried everything I can think
of to get it fixed. Retyped the cell contents; copied to it from another
cell. Nothing works. I can see the text on the screen and in print preview
but it just doesn't come out on the paper. Here is the text I'm trying to
print out:

Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2quot;

Now, there's nothing special about that, is there? Why won't it print? What
have I done wrong? Same font, same cell formatting as other cells.
--
Jim H.

I would recommend,
Delete the entire row....
Insert a new row....
Retype the data in that new row......

Vaya con Dios,
Chuck, CABGx3quot;Jim H.quot; gt; wrote in message
...
gt; I'm at my wits end! There is this cell in my spreadsheet that won't print
(on
gt; paper). Everything else around it prints. I've tried everything I can
think
gt; of to get it fixed. Retyped the cell contents; copied to it from another
gt; cell. Nothing works. I can see the text on the screen and in print preview
gt; but it just doesn't come out on the paper. Here is the text I'm trying to
gt; print out:
gt;
gt; Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2quot;
gt;
gt; Now, there's nothing special about that, is there? Why won't it print?
What
gt; have I done wrong? Same font, same cell formatting as other cells.
gt; --
gt; Jim H.
Have you tried File/Print Area/Clear Print Area?quot;Jim H.quot; wrote:

gt; I'm at my wits end! There is this cell in my spreadsheet that won't print (on
gt; paper). Everything else around it prints. I've tried everything I can think
gt; of to get it fixed. Retyped the cell contents; copied to it from another
gt; cell. Nothing works. I can see the text on the screen and in print preview
gt; but it just doesn't come out on the paper. Here is the text I'm trying to
gt; print out:
gt;
gt; Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2quot;
gt;
gt; Now, there's nothing special about that, is there? Why won't it print? What
gt; have I done wrong? Same font, same cell formatting as other cells.
gt; --
gt; Jim H.

Yes, Chuck, that was the first thing I tried. No Go.

JMB, Good suggestion but fiddling around with the print area doesn't work
either.

My cell still won't print. BTW, I sorted my list and not a bunch of other
random cells in column E won't print along with the initial cell that
wouldn't print in column C (which is, due to the sort, on a different row
number. Thus, the problem followed the repositioning of the sort.)

Has anyone else seen this problem before?

--
Jim H.quot;Jim H.quot; wrote:

gt; I'm at my wits end! There is this cell in my spreadsheet that won't print (on
gt; paper). Everything else around it prints. I've tried everything I can think
gt; of to get it fixed. Retyped the cell contents; copied to it from another
gt; cell. Nothing works. I can see the text on the screen and in print preview
gt; but it just doesn't come out on the paper. Here is the text I'm trying to
gt; print out:
gt;
gt; Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2quot;
gt;
gt; Now, there's nothing special about that, is there? Why won't it print? What
gt; have I done wrong? Same font, same cell formatting as other cells.
gt; --
gt; Jim H.

OK, I found out why the cell wasn't printing but I don't understand why. Some
one will have to tell me why. Here's how I fixed the problem. The cell that
wasn't printing contained the following text:

Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2quot;

I deleted the double-quote character from the end of the string so that the
string looks like this:

Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2

It printed fine. So, I put the double-quote back and it again wouldn't
print. Why is this happening? I have other cells with strings ending in a
double-quote in the same column and they print fine such as the following:

P-Trap, PVC, Black, 1-1/4quot;

Why O Why?

--
Jim H.quot;Jim H.quot; wrote:

gt; I'm at my wits end! There is this cell in my spreadsheet that won't print (on
gt; paper). Everything else around it prints. I've tried everything I can think
gt; of to get it fixed. Retyped the cell contents; copied to it from another
gt; cell. Nothing works. I can see the text on the screen and in print preview
gt; but it just doesn't come out on the paper. Here is the text I'm trying to
gt; print out:
gt;
gt; Pine, Clear, 1 x 6 x 7' (Door Jamb), Ripped into 3 pieces ea 1-1/2quot;
gt;
gt; Now, there's nothing special about that, is there? Why won't it print? What
gt; have I done wrong? Same font, same cell formatting as other cells.
gt; --
gt; Jim H.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()