Tables

Dear Martina

Thank you for attending Excel 2007 Intremediate course!! I hope you enjoyed the course and benefited from it.

There are two methods. One is Page Break Preview and the other one is in The Page Setup dialog box Scaling feature.

On the Ribbon you choose View Tab.

Then you click on the Page Break View Button.

You simply drag the Blue line to the desired locations to fit the data on the relevant pages of your choice.

If you wish to insert a manual Page Break then simply select the Row or Column and right click.

Choose the Insert Page Break option from the short cut menu. The new Page break will be inserted on the left hand side of the selected column or Above the Row that you selected.

If you wish to use the Page Setup dialog box then simply On the Ribbon choose the Page Layout Tab.

Click on the Dialog box launcher button (a small diagonal arrow) of the Page Set up group.

Choose the Page tab and then adjust the scaling.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Hello Martina

Thank you for your question and welcome to the forum.

There are a couple of print settings you can adjust to fit more on one page when you print a spreadsheet.

Go to the Page Layout ribbon, Page Setup group and click the small arrow in the bottom right hand corner of the group of buttons.

Go to the Page tab, where you can adjust scaling (making scaling smaller than 100% will fit more on the page), or select the Fit to 1 page wide by 1 page tall option; then click OK.

Use Print preview to check how the spreadsheet will look before printing.

Kind regards
Amanda