98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel page breaks
Excel page breaks
Resolved · High Priority · Version 2010
Wed 8 Jun 2016, 08:40Delegate Michelle said...
Michelle has attended:
Excel Introduction course
Excel Intermediate course
Excel page breaks
I have received a document which has numerous page breaks inserted. This document should print on one page but I cannot remove the page breaks. How do I do this?
Wed 8 Jun 2016, 11:24Trainer Richard said...
RE: Excel page breaks
Hi Michelle,
To reset the page breaks:
On the Page Layout tab along the top click on Breaks.
There's a drop down arrow underneath Breaks, click on it and choose Reset Breaks.
Another alternative is:
When you go to Print - You could click on the No Scaling button at the bottom, and select Fit Sheet on One Page.
Let me know if that helped.
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 8 Jun 2016, 11:31Delegate Michelle said...
RE: Excel page breaks
Hi. Thanks for getting back to me. Neither of these things worked. Can you advise what I should do next? Interestingtly, when I email it to a colleague the unwanted page breaks do not appear on the document. FYI this is a timesheet template which is upated and sent to me weekly from various people.
Many thanks
Wed 8 Jun 2016, 11:28Delegate Michelle said...
RE: Excel page breaks
Hi. These two things did not work. Please advise. Many thanks
Wed 8 Jun 2016, 11:55Trainer Richard said...
RE: Excel page breaks
Hi Michelle,
I've sent you an email to reply to. I can't tell whether this is a Page Break issue or an Excel "View" issue. The fact you can email it and it doesn't have the issue makes me suspect it's something else
Thanks
Richard
Wed 15 Jun 2016: Automatically marked as resolved.
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:Quickly insert a functionIn Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog. |
