Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I make a spreadsheet fit the right margin.
when I print out a excel spreadsheet the right margin is cut off and what
little is left is printed on another page. How do I correct this? I need to get all the data on one page. |
#2
|
|||
|
|||
Hi ....,
Basically could try fit page to width, ikf you fail with other measures File, Page Setup, Page [x] Fit to 1 page(s) wide by [leave blank] tall The two dimensions are independent of one another use either or both as needed. Other tricks: You can change page margins the easiest from Print Preview. You have a choice of Landscape or Portrait (File, Page Setup, Page) Reduce the fontsize for a really large name if it only happens in a cell or two. Reduce the fontsize for an entire column(s) Turn on "warp text" (format, cells, alignment, wrap text) and reduce width of a column. You will end up with some cells having more than one line. If you can't fit on a page you should know about file, Page Setup, Sheet Rows to repeat at top i.e. $1:$1 or $1:$2 Columns to repeat at left i.e. $A:$A. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "cwood" wrote in message ... when I print out a excel spreadsheet the right margin is cut off and what little is left is printed on another page. How do I correct this? I need to get all the data on one page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make one spreadsheet retrieve info from previous spreadshee. | Excel Discussion (Misc queries) | |||
Make an Access Database out of Excel spreadsheet | New Users to Excel | |||
how do I make the left margin of a header the same as the page ma. | Excel Discussion (Misc queries) | |||
how do I make excel 2003 my default spreadsheet over ms works spr. | Setting up and Configuration of Excel | |||
How do I make a column that calculates gross margin percentage | Excel Worksheet Functions |