Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
buddyorliz
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
buddyorliz
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print graphs poster size (4 - 8 1/2 x 11) in Excel 2002? Library Dragon Charts and Charting in Excel 1 June 26th 05 04:22 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
EXCEL, VSTO: Fastest way to access multiple cells Alan Excel Discussion (Misc queries) 1 June 1st 05 02:45 PM
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM
How do I print all sheets of an Excel workbook from explorer? Dave Walker Excel Discussion (Misc queries) 1 January 28th 05 09:19 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"