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 formatting
Excel formatting
Resolved · High Priority · Version 2007
Chloe has attended:
Excel Intermediate course
Project Intermediate course
Excel formatting
I seem to have formatted my spreadsheet strangely -
page breaks for every cell when I try to set one page wide.
It won't adjust as it would do normally...
Please help!
Thanks
RE: Excel formatting
Hello Chloe,
Thank you for your enquiry regarding strangely behaving page breaks.
There are a couple of things you can try.
1. Copy and paste the worksheet into a new document and then check the page breaks.
2. From the Page Layout ribbon, Page Setup group, select Print Titles. From the dialogue box, select the Page tab and in the Scaling section, fill in the Fit to options.
Hopefully one of these methods will resolve the problem. If not, let me know and we'll try something else.
Kind regards
Cindy
Microsoft Office Trainer
RE: Excel formatting
Hello Chloe,
Thank you for your enquiry regarding strangely behaving page breaks.
There are a couple of things you can try.
1. Copy and paste the worksheet into a new document and then check the page breaks.
2. From the Page Layout ribbon, Page Setup group, select Print Titles. From the dialogue box, select the Page tab and in the Scaling section, fill in the Fit to options.
Hopefully one of these methods will resolve the problem. If not, let me know and we'll try something else.
Kind regards
Cindy
Microsoft Office Trainer
Wed 14 Nov 2012: 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:Manually rotating a 3D chartTo manually rotate a 3D chart; |