Quick Links ▼

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft-excel-training - Excel Printing

Resolved · Low Priority · Version Standard

Reply Wed 12 Dec 2007, 15:38Delegate Kimi said...

Kimi has attended:
Excel Introduction course

Excel Printing

How do you re size a speadsheet that is both too wide and too long? How does it look if it is printed if it cannot be re sized?

For upcoming training course dates see: Pricing & availability

Reply Fri 14 Dec 2007, 15:12Trainer Andrew said...

RE: Excel Printing

Hi Kimi

thanks for your question.

You can force Excel to fit your document size but remember that large documents forced to A4 will have to be scaled down to fit, possibly limiting readability.

From the file menu choose page setup. From the Page tab either choose to force the print out to fit x tall by y wide or modify the scale to reduce the size of the output.

I hope this is helpful - do let us know if you have any further questions.

Kind regards,

Andrew

Excel articles

· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· The Secret Formula To Creating Correct Calculations In Excel
· Creating Charts with Excel
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· Improve Performance Of Your Excel Macros

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips