Thursday 25 February 2010

Fiting all data on one page.



Is there a way to fit all the data on one page?
First Option.
Firstly you should shrink the columns
1.Click Page Setup on the File menu.
2.On the Page tab, click Fit to, and enter 1 in the page(s) wide box.

Tip:You can also change the font size, because it's might be to big and because of this not all information fits on one page.
You may want to preview the page again to make sure the font size isn't too small.
Second Option.
Secondly you might adjust margins so it fits.
1. To fit a few more columns on the printed page, you can adjust the width of margins or columns.
2. Click Page Setup on the File menu.
On the Margins tab, specify the size for the margin in the Top, Right, Bottom, and Left boxes.

For Full tutorial visit http://office.microsoft.com/en-us/excel/HA010346461033.aspx
or
http://www.ehow.com/how_2167701_fit-excel-sheet-one-page.html

You could use Msn to contact Microsoft Help Desk and speak with them directly.

No comments:

Post a Comment