Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/2" 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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would recommend,
Delete the entire row.... Insert a new row.... Retype the data in that new row...... Vaya con Dios, Chuck, CABGx3 "Jim H." wrote in message ... 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/2" 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have you tried File/Print Area/Clear Print Area?
"Jim H." wrote: 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/2" 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. "Jim H." wrote: 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/2" 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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/2" 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/4" Why O Why? -- Jim H. "Jim H." wrote: 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/2" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) |