microsoft-excel-training - excel printing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

microsoft-excel-training - Excel Printing

resolvedResolved · Low Priority · Version Standard

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?

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 tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips


Server loaded in 0.09 secs.