Home |
Search |
Today's Posts |
#1
|
|||
|
|||
print view & print, in excel, different size cells
When I print (or view preview print) sometimes information that is in a cell
is cut off, or extended. While I am working on the page I formate the cell how I want it, like say I have the word "Coummunity" in the First cell and have it formated to center or wrap or shrink to fit..... I stretch the cell so the whole word will fit, but when I print it, it might have Coummuni on one line and ty wrapped. Or if I have two or three words in a cell that is formated to wrap and while I am looking at it all three words are stacked, the way I want them, say on three lines, but when it is printed it is wrong. Sometimes while adding the data, I havent gotten it fromated right yet, But on the print preview it is fine???? |
#2
|
|||
|
|||
WYSIWYG ain't necessarily true.
I think the only way you'll know for sure is to look at the hardcopy. And to make matters worse, a different user could have a different printer and the hardcopy could be different. Can you make the rowheight or columnwidth larger to cover worse case -- or change the font size to something smaller? buddyorliz wrote: When I print (or view preview print) sometimes information that is in a cell is cut off, or extended. While I am working on the page I formate the cell how I want it, like say I have the word "Coummunity" in the First cell and have it formated to center or wrap or shrink to fit..... I stretch the cell so the whole word will fit, but when I print it, it might have Coummuni on one line and ty wrapped. Or if I have two or three words in a cell that is formated to wrap and while I am looking at it all three words are stacked, the way I want them, say on three lines, but when it is printed it is wrong. Sometimes while adding the data, I havent gotten it fromated right yet, But on the print preview it is fine???? -- Dave Peterson |
#3
|
|||
|
|||
That is true - though I have never seen it written that way "WYSIWYG"
I never had this probablem before and have been using excel (office products) for years. It is inportant for what I see on the screen to be what I see in the print view, And of course what is printed. Yes changing the font size or the cell size does make a difference. "Dave Peterson" wrote: WYSIWYG ain't necessarily true. I think the only way you'll know for sure is to look at the hardcopy. And to make matters worse, a different user could have a different printer and the hardcopy could be different. Can you make the rowheight or columnwidth larger to cover worse case -- or change the font size to something smaller? buddyorliz wrote: When I print (or view preview print) sometimes information that is in a cell is cut off, or extended. While I am working on the page I formate the cell how I want it, like say I have the word "Coummunity" in the First cell and have it formated to center or wrap or shrink to fit..... I stretch the cell so the whole word will fit, but when I print it, it might have Coummuni on one line and ty wrapped. Or if I have two or three words in a cell that is formated to wrap and while I am looking at it all three words are stacked, the way I want them, say on three lines, but when it is printed it is wrong. Sometimes while adding the data, I havent gotten it fromated right yet, But on the print preview it is fine???? -- Dave Peterson |
#4
|
|||
|
|||
It's a pretty common term:
http://www.google.com/search?hl=en&q...=Google+Search I know of no way to ensure what you want. buddyorliz wrote: That is true - though I have never seen it written that way "WYSIWYG" I never had this probablem before and have been using excel (office products) for years. It is inportant for what I see on the screen to be what I see in the print view, And of course what is printed. Yes changing the font size or the cell size does make a difference. "Dave Peterson" wrote: WYSIWYG ain't necessarily true. I think the only way you'll know for sure is to look at the hardcopy. And to make matters worse, a different user could have a different printer and the hardcopy could be different. Can you make the rowheight or columnwidth larger to cover worse case -- or change the font size to something smaller? buddyorliz wrote: When I print (or view preview print) sometimes information that is in a cell is cut off, or extended. While I am working on the page I formate the cell how I want it, like say I have the word "Coummunity" in the First cell and have it formated to center or wrap or shrink to fit..... I stretch the cell so the whole word will fit, but when I print it, it might have Coummuni on one line and ty wrapped. Or if I have two or three words in a cell that is formated to wrap and while I am looking at it all three words are stacked, the way I want them, say on three lines, but when it is printed it is wrong. Sometimes while adding the data, I havent gotten it fromated right yet, But on the print preview it is fine???? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print graphs poster size (4 - 8 1/2 x 11) in Excel 2002? | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) |