excel formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel formatting

Excel formatting

resolvedResolved · 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.


 

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips


Server loaded in 0.08 secs.