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
