Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
When I print a sheet, I see text that is not on the same cell when viewing
the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
Tell us what you see, both on the screen, and on the printed page.
-- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
In a cell, for example, on the screen it is blank. When the page is printed,
the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
Here are my suggestions for troubleshooting:
1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
I was printing in color, and did change to black as you suggested. Now this
is very odd. In the cells where nothing is seen on the screen, when I print in black, the text does not print - only prints when color option is chosen. But the problem is not in the printing ( now it is ), it is on the screen. The text prints in color - but not black, but is not seen on the screen either way. I told you about the cell sizes because I thought it would be a clue. The lines for the small €śdifferent€ť cells don't show up on the page printed in black, but do show up as one "double" line on the color printed page. A normal cell has the border: "Outline" is chosen, and on the box below that says "text" the black border is shown around the entire box. But on the "problem" column/cells, the border chosen is "outline" -- but on the box below that says "text" only the sides of the box show the black border. Nothing shows on the top or bottom of the cell in the border tab of "format cells" menu, but on the screen you see a very light line that differentiates the different cells. Also when I opened the format box to un-click the "merge cells" choice as you suggested, it was already un-clicked. Apparently, a default removed my check mark. "Fred Smith" wrote: Here are my suggestions for troubleshooting: 1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
Can we assume that you want all these cells to print with the same format?
If so, copy the format from a good cell to a problem cell. Better yet, make sure all the cells have the same format. Highlight the top left cell in the range in question. Right-click on the fill handle and drag to select the entire range, When you release the mouse button, choose Fill Formatting Only. Now all cells will have the same formatting. Does that solve your problem? -- Regards, Fred "stevemalee" wrote in message ... I was printing in color, and did change to black as you suggested. Now this is very odd. In the cells where nothing is seen on the screen, when I print in black, the text does not print - only prints when color option is chosen. But the problem is not in the printing ( now it is ), it is on the screen. The text prints in color - but not black, but is not seen on the screen either way. I told you about the cell sizes because I thought it would be a clue. The lines for the small "different" cells don't show up on the page printed in black, but do show up as one "double" line on the color printed page. A normal cell has the border: "Outline" is chosen, and on the box below that says "text" the black border is shown around the entire box. But on the "problem" column/cells, the border chosen is "outline" -- but on the box below that says "text" only the sides of the box show the black border. Nothing shows on the top or bottom of the cell in the border tab of "format cells" menu, but on the screen you see a very light line that differentiates the different cells. Also when I opened the format box to un-click the "merge cells" choice as you suggested, it was already un-clicked. Apparently, a default removed my check mark. "Fred Smith" wrote: Here are my suggestions for troubleshooting: 1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
When I drag across all the cells, I get a message saying that the operation
requires merged cells to be identically sized. Across the row, some of the cells are "good" and the others have the extra light lines in them. If I remove "merge cells" from the "good" cells, then the good cells have the light lines in them. If I drag across 2 "good cells" then the data from one is copied into the other and I don't want the same data. Apparantly it is "autofilling" since when I go to edit it says to "undo autofill" "Fred Smith" wrote: Can we assume that you want all these cells to print with the same format? If so, copy the format from a good cell to a problem cell. Better yet, make sure all the cells have the same format. Highlight the top left cell in the range in question. Right-click on the fill handle and drag to select the entire range, When you release the mouse button, choose Fill Formatting Only. Now all cells will have the same formatting. Does that solve your problem? -- Regards, Fred "stevemalee" wrote in message ... I was printing in color, and did change to black as you suggested. Now this is very odd. In the cells where nothing is seen on the screen, when I print in black, the text does not print - only prints when color option is chosen. But the problem is not in the printing ( now it is ), it is on the screen. The text prints in color - but not black, but is not seen on the screen either way. I told you about the cell sizes because I thought it would be a clue. The lines for the small "different" cells don't show up on the page printed in black, but do show up as one "double" line on the color printed page. A normal cell has the border: "Outline" is chosen, and on the box below that says "text" the black border is shown around the entire box. But on the "problem" column/cells, the border chosen is "outline" -- but on the box below that says "text" only the sides of the box show the black border. Nothing shows on the top or bottom of the cell in the border tab of "format cells" menu, but on the screen you see a very light line that differentiates the different cells. Also when I opened the format box to un-click the "merge cells" choice as you suggested, it was already un-clicked. Apparently, a default removed my check mark. "Fred Smith" wrote: Here are my suggestions for troubleshooting: 1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
Hi Fred,
Did you see my last message? Below? "stevemalee" wrote: When I drag across all the cells, I get a message saying that the operation requires merged cells to be identically sized. Across the row, some of the cells are "good" and the others have the extra light lines in them. If I remove "merge cells" from the "good" cells, then the good cells have the light lines in them. If I drag across 2 "good cells" then the data from one is copied into the other and I don't want the same data. Apparantly it is "autofilling" since when I go to edit it says to "undo autofill" "Fred Smith" wrote: Can we assume that you want all these cells to print with the same format? If so, copy the format from a good cell to a problem cell. Better yet, make sure all the cells have the same format. Highlight the top left cell in the range in question. Right-click on the fill handle and drag to select the entire range, When you release the mouse button, choose Fill Formatting Only. Now all cells will have the same formatting. Does that solve your problem? -- Regards, Fred "stevemalee" wrote in message ... I was printing in color, and did change to black as you suggested. Now this is very odd. In the cells where nothing is seen on the screen, when I print in black, the text does not print - only prints when color option is chosen. But the problem is not in the printing ( now it is ), it is on the screen. The text prints in color - but not black, but is not seen on the screen either way. I told you about the cell sizes because I thought it would be a clue. The lines for the small "different" cells don't show up on the page printed in black, but do show up as one "double" line on the color printed page. A normal cell has the border: "Outline" is chosen, and on the box below that says "text" the black border is shown around the entire box. But on the "problem" column/cells, the border chosen is "outline" -- but on the box below that says "text" only the sides of the box show the black border. Nothing shows on the top or bottom of the cell in the border tab of "format cells" menu, but on the screen you see a very light line that differentiates the different cells. Also when I opened the format box to un-click the "merge cells" choice as you suggested, it was already un-clicked. Apparently, a default removed my check mark. "Fred Smith" wrote: Here are my suggestions for troubleshooting: 1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
Yes I did. However, I didn't see any answers to my questions, so I thought we'd
quit wasting each other's time. If you want to give it another go, here are my questions: Before you drag, did you eliminate all merged cells? I asked you to eliminate the merged cells, because they could well be the source of your problem. When you drag, do you use the left-mouse button or the right? I asked you to drag with the right button. That way, when you release it, you get a message allowing you to fill formatting only. That's what stops copying the data, as I know you want only the formatting copied, not the data. And yes, I'm aware that this method of dragging is called autofilling in Excel. -- Regards, Fred "stevemalee" wrote in message ... Hi Fred, Did you see my last message? Below? "stevemalee" wrote: When I drag across all the cells, I get a message saying that the operation requires merged cells to be identically sized. Across the row, some of the cells are "good" and the others have the extra light lines in them. If I remove "merge cells" from the "good" cells, then the good cells have the light lines in them. If I drag across 2 "good cells" then the data from one is copied into the other and I don't want the same data. Apparantly it is "autofilling" since when I go to edit it says to "undo autofill" "Fred Smith" wrote: Can we assume that you want all these cells to print with the same format? If so, copy the format from a good cell to a problem cell. Better yet, make sure all the cells have the same format. Highlight the top left cell in the range in question. Right-click on the fill handle and drag to select the entire range, When you release the mouse button, choose Fill Formatting Only. Now all cells will have the same formatting. Does that solve your problem? -- Regards, Fred "stevemalee" wrote in message ... I was printing in color, and did change to black as you suggested. Now this is very odd. In the cells where nothing is seen on the screen, when I in black, the text does not print - only prints when color option is chosen. But the problem is not in the printing ( now it is ), it is on the screen. The text prints in color - but not black, but is not seen on the screen either way. I told you about the cell sizes because I thought it would be a clue. The lines for the small "different" cells don't show up on the page printed in black, but do show up as one "double" line on the color printed page. A normal cell has the border: "Outline" is chosen, and on the box below that says "text" the black border is shown around the entire box. But on the "problem" column/cells, the border chosen is "outline" -- but on the box below that says "text" only the sides of the box show the black border. Nothing shows on the top or bottom of the cell in the border tab of "format cells" menu, but on the screen you see a very light line that differentiates the different cells. Also when I opened the format box to un-click the "merge cells" choice as you suggested, it was already un-clicked. Apparently, a default removed my check mark. "Fred Smith" wrote: Here are my suggestions for troubleshooting: 1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printed sheet shows text not seen on monitor screen
I thought I was answering/telling you what you asked me to do- and what
happened when I did it, that it didn't work. So, let me try again. I un-clicked all the cells that were merged and now all the big/good cells have 3 small cells inside them. The problem is that I see for example rows 7, 8, & 9 inside an area that has the border around it, and that is what I want to be the big/good cell -- the area that has the heavy black border, not the 3 small rows. The big/good "cell" is the one that prints. All the cells are not merged. I used the right button to drag and did choose fill formatting only. What then happens is my dates do not show up correctly. I checked how the dates are formatted and all cells show date formats the same. Some dates are correct, and some are a string of numbers making no sense. So, I did what you asked. I un-merged all the cells and I used the right button to drag. But I still have the problem. Thanks for being so patient "Fred Smith" wrote: Yes I did. However, I didn't see any answers to my questions, so I thought we'd quit wasting each other's time. If you want to give it another go, here are my questions: Before you drag, did you eliminate all merged cells? I asked you to eliminate the merged cells, because they could well be the source of your problem. When you drag, do you use the left-mouse button or the right? I asked you to drag with the right button. That way, when you release it, you get a message allowing you to fill formatting only. That's what stops copying the data, as I know you want only the formatting copied, not the data. And yes, I'm aware that this method of dragging is called autofilling in Excel. -- Regards, Fred "stevemalee" wrote in message ... Hi Fred, Did you see my last message? Below? "stevemalee" wrote: When I drag across all the cells, I get a message saying that the operation requires merged cells to be identically sized. Across the row, some of the cells are "good" and the others have the extra light lines in them. If I remove "merge cells" from the "good" cells, then the good cells have the light lines in them. If I drag across 2 "good cells" then the data from one is copied into the other and I don't want the same data. Apparantly it is "autofilling" since when I go to edit it says to "undo autofill" "Fred Smith" wrote: Can we assume that you want all these cells to print with the same format? If so, copy the format from a good cell to a problem cell. Better yet, make sure all the cells have the same format. Highlight the top left cell in the range in question. Right-click on the fill handle and drag to select the entire range, When you release the mouse button, choose Fill Formatting Only. Now all cells will have the same formatting. Does that solve your problem? -- Regards, Fred "stevemalee" wrote in message ... I was printing in color, and did change to black as you suggested. Now this is very odd. In the cells where nothing is seen on the screen, when I in black, the text does not print - only prints when color option is chosen. But the problem is not in the printing ( now it is ), it is on the screen. The text prints in color - but not black, but is not seen on the screen either way. I told you about the cell sizes because I thought it would be a clue. The lines for the small "different" cells don't show up on the page printed in black, but do show up as one "double" line on the color printed page. A normal cell has the border: "Outline" is chosen, and on the box below that says "text" the black border is shown around the entire box. But on the "problem" column/cells, the border chosen is "outline" -- but on the box below that says "text" only the sides of the box show the black border. Nothing shows on the top or bottom of the cell in the border tab of "format cells" menu, but on the screen you see a very light line that differentiates the different cells. Also when I opened the format box to un-click the "merge cells" choice as you suggested, it was already un-clicked. Apparently, a default removed my check mark. "Fred Smith" wrote: Here are my suggestions for troubleshooting: 1. Unmerge the cells. Everything I've read on this forum says merged cells are more trouble than they are worth, and could be the source of your problem. 2. Print on a color printer. You may have a print color and a background color which cancel each other out in color display, but don't in black and white. 3. Can you tell where the printed text is coming from? Is it an adjacent cell? When you say "There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this.", what problem do you want solved? -- Regards, Fred "stevemalee" wrote in message ... In a cell, for example, on the screen it is blank. When the page is printed, the "blank cell" has printed text. This happens on only one column and in 2-3 cells of that column. I checked the format cells and it shows word wrap, merge cells, and left to right. The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows. The other odd thing is the cell size in the columns on the left and right of the "problem column" are the desired size. There are 3 small cells in the same size on the "problem column" and I can't figure out how to correct this. Thanks for your continued assistance. "Fred Smith" wrote: Tell us what you see, both on the screen, and on the printed page. -- Regards, Fred "stevemalee" wrote in message ... When I print a sheet, I see text that is not on the same cell when viewing the monitor of the same page. This has caused me many problems, but until now I did not know why I had problems. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display the cell it goes to at the centre of the monitor screen? | Excel Discussion (Misc queries) | |||
How do I hide words on a printed document, but see on screen? | Excel Discussion (Misc queries) | |||
CELL & TEXT COLORS DO NOT CHANGE ON MY PC MONITOR | Excel Discussion (Misc queries) | |||
Show colour on screen in Excel as printed in Excel | Setting up and Configuration of Excel | |||
Why does the formula result show a number but the screen shows ze. | Excel Worksheet Functions |