Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Tables
Resolved · Low Priority · Version 2007
Reply Tue 16 Jun 2009, 14:37Delegate Martina said...
Martina has attended:
Excel Intermediate course
Tables
How do you make a table size smaller to fit onto the page.
For upcoming training course dates see: Pricing & availability
RE: 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
RE: Tables
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
Wed 24 Jun 2009: Automatically marked as resolved.
|