98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Page Setup
excel training microsoft - Page Setup
Resolved · Low Priority · Version Standard
Merline has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Page Setup
How do I fit my spreadsheet over 3 pages in stead of just one.
RE: Page Setup
Dear Merline
Thank you for attending our Excel Course.
I understand that you might be trying to fit a one page spreadsheet in to three by using the scaling option in Page setup.
I agree that it is a bit misleading. The scaling option works in a particular manner. If you have few pages and trying to fit them in more pages then Scaling option in Page setup will not work. This is particularly useful if you have more pages and trying to fit them in fewer pages. The best example is when you have four pages of data and there are only three-four columns or rows in the last page.
Please note by scaling you are compromising with the size of your data.
If you want to fit one page worksheet in three pages then you have to select the Columns or rows and insert a manual page break. Please remember that the new page break gets inserted on the left of the selected column and top of the selected row.
If you want to see the instant effect of the page breaks then it is suggested that perform the manual page breaks in Page Break Preview. You can access the Page break Preview by choosing View > Page Break Preview.
I hope this helps
If this has helped in answering your query Please mark this query as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS master Instructor 2000 and 2003
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. |
Excel tip:Naming and Using ConstantsConstants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant. |