Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

2002 excel microsoft training - Excel

Resolved · Low Priority · Version Standard

Reply Wed 12 Dec 2007, 15:37Delegate Paola said...

Paola has attended:
Excel Introduction course

Excel

How do i format my data so it fits onto one page when printing?

For upcoming training course dates see: Pricing & availability

Reply Fri 14 Dec 2007, 15:46Trainer Amanda said...

RE: Excel

Hi Paola

Thank you for your question.

You can use one of two settings in Page Setup in Excel (File - Page Setup - Page tab).

You can try reducing the Scaling down from 100%; or you can select the option to Fit to 1 page wide by 1 page tall (directly underneath scaling).

Then click the Print Preview button on the right hand side of the screen to preview the changes and make sure you are happy with how this will print before you print it out.

I hope this helps.
Amanda

Excel articles

· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel can ensure you keep on top of your finances
· Benefits of learning about Excel charts
· Fun Things I've Done With Excel
· Excel in the Home Office

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips