Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Expand text/information to fill sheet for printing

I am trying to ascertain if there is a method by which I can cause
text/information on a worksheet to expand, and thereby fill the entire page
(print preview for instance). I have a document that, when viewed on screen,
is certainly fine for working with and in due to the ability to zoom the
view. However, when I print said document, it fills perhaps a quarter of the
paper, and is hideously small.

Is there a way to expand, zoom perhaps, the worksheet text so that it will
fill the page when printed without having to go in and manually adjust every
font size, column width, and/or margin setting?

Thank you for your time and attention.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default Expand text/information to fill sheet for printing

You could create a text box and copy and past the text into it. Once the text
is in the text box you can manipulate the box to fit the screen. If you dont
want the border around the box just select the box, right click, format text
box, choose the color and lines tab, and under line, no line.

"JsGuero" wrote:

I am trying to ascertain if there is a method by which I can cause
text/information on a worksheet to expand, and thereby fill the entire page
(print preview for instance). I have a document that, when viewed on screen,
is certainly fine for working with and in due to the ability to zoom the
view. However, when I print said document, it fills perhaps a quarter of the
paper, and is hideously small.

Is there a way to expand, zoom perhaps, the worksheet text so that it will
fill the page when printed without having to go in and manually adjust every
font size, column width, and/or margin setting?

Thank you for your time and attention.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Expand text/information to fill sheet for printing

I have successfully used the setup from print preview for exactly what you
are suggesting. After going to print preview just click setup. You can
choose to magnify the output or tell it to fit to however many pages you want
it to fill. Try experimenting until you get the output you would like. This
should allow you to expand the printout to fill the page and make it more
visually friendly.

Hope that helps!

"JsGuero" wrote:

I am trying to ascertain if there is a method by which I can cause
text/information on a worksheet to expand, and thereby fill the entire page
(print preview for instance). I have a document that, when viewed on screen,
is certainly fine for working with and in due to the ability to zoom the
view. However, when I print said document, it fills perhaps a quarter of the
paper, and is hideously small.

Is there a way to expand, zoom perhaps, the worksheet text so that it will
fill the page when printed without having to go in and manually adjust every
font size, column width, and/or margin setting?

Thank you for your time and attention.

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
Expand text/information to fill sheet for printing JsGuero Excel Discussion (Misc queries) 1 April 26th 10 02:54 PM
Expand sheet as information is entered akkrug New Users to Excel 2 June 18th 09 08:45 PM
Auto fill-in text and importing information Gabe Excel Discussion (Misc queries) 1 September 28th 07 03:20 AM
Auto fill of cell with information from seperate sheet Ray Excel Worksheet Functions 1 June 14th 07 01:19 AM
how to auto fill information from a table to another sheet cmaki1975 Excel Worksheet Functions 1 January 15th 07 05:34 PM


All times are GMT +1. The time now is 10:30 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"