LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.printing,microsoft.public.excel.newusers
external usenet poster
 
Posts: 113
Default Poor fit-to-page printouts

Thank you macropod. I appreciate the possible work-around. However, this
obviously does not eliminate the frustration associated with such problems.
What is so hard about printing a scaled drawing that prints fine at 100
percent? It seems that if all the elements are scaled equally then
everything should print the same at the new size. Furthermore, this case is
especially perplexing since the column width for the phone numbers already
provides a huge degree of extra blank space compared to many other columns
that print without any problem.

Thanks,

Richard

******************
"macropod" wrote in message
...
Hi Blue Max,

Excel's wysiwig capabilities at different zoom factors (print or view) are
not entirely consistent - even changing the view zoom factor can have
similar effects on the display to what you're experiencing with the print.

On that basis, though, here's a possible workaround: After setting the
zoom factor for the 'fit to page' result, try zooming the active window to
the same or marginally smaller percentage scaling, then adjusting the
column widths to suit that scale.


--
Cheers
macropod
[Microsoft MVP - Word]


"Blue Max" wrote in message
...
Thank you for the reply, but I don't really understand the
recommendation. The phone numbers do not have any unwanted spaces. They
are simply put in as a series of 10 numbers and the built-in-format
formats the number with the area code between parens, a space between the
area code and prefix, and a hyphen between the prefix and 4-digit number.

As such, there are no unwanted spaces or other characters in the cell
contents. Furthermore, we are not sure how this would affect printing.
Text in cells and narrative in text boxes print fine with all sorts of
characters, including spaces.

Please clarify.

*******************
"Ms-Exl-Learner" wrote in message
...
I think you have to clear the unwanted spaces from the phone number data.
Have a Look at Trim Function for the same.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Blue Max" wrote:

How come cell contents become non-printable when the printout is fit
to the
page? We have worksheets that display and print fine at 100%, but
print
poorly when fit to the page. In fact, the problem is evident in the
print
preview
even before printing. Shouldn't the program simply reduce all elements
so
they
will print as in normal mode only smaller?

For example, in one sheet we have a column of phone numbers formatted
with
the special format for phone numbers. The column is plenty wide and
contains
more blank space per cell, including the contents, than many other
cells.
Notwithstanding, the phone numbers all print as asterisks (*),
indicating
the content won't fit in the designated cell, when the printout is
forced to
scale the printout to one page.

This problem is most frustrating since it appears that the worksheet is
well-designed and should print fine. Any thoughts or suggestions on
how to
properly print our worksheets when reduced to fit the page?






 
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
Poor fit-to-page printouts Blue Max New Users to Excel 0 October 4th 09 09:18 PM
Font Colors not reflected on printouts thegrx Excel Discussion (Misc queries) 2 August 26th 09 03:02 PM
Blank Printouts and Print Preview Jack Excel Worksheet Functions 1 November 9th 05 09:58 PM
Font Colors not reflected on printouts PaulP Excel Discussion (Misc queries) 2 October 10th 05 07:37 PM
I can't change the font size in the printouts? james Excel Discussion (Misc queries) 2 September 10th 05 04:47 PM


All times are GMT +1. The time now is 10:22 AM.

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

About Us

"It's about Microsoft Excel"