how do I make a spreadsheet fit the right margin.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

margins keeping changing 1
Printing 1
I can't get the lower margin to zero in Excel 3
Outlook 2003 margin error when printing 4
how do i set different margins within document 1
Cell margins ? 3
print spreadsheet 1
Margins 2

Back
Top