Excel Knowledge Req.

[hlxbravo]

Hiya guys and girls, not having used Excel 2010 before, I put myself onto a work ICT course for the sole purpose of learning a little about it. We are currently doing formulas and I have come across something the tutor cannot answer.

We have a basic table showing various accounts, our page layout is horizontal with narrow margin, we have to do various tasks with this table, one of which is adding up values with formulas....then printing them out and herein lies the question.

We print out the standard view table, then select show formulas but now it is outside of the page layout borders and we have been told to manually adjust the column widths to make it fit on page. Is this the only way to do it because when we have done this, the standard view has also shrunk.To overcome this now smaller table, the tutor said the best way is to create the standard table and use "save as" to create the file such as Document-noformula, then use show formula, adjust columns to fit page again and "save as" Document-formula. This way she said we would have both versions available

Surely there is a setting that will auto set/adjust to correct this, I have Google this but with no joy. So can anyone offer some advice ?

Cheers.

 

[andshrew]

In Page Setup there are auto scaling options which, depending on how much data you have, may help automate this. Using 'Fit to' it would automatically reduce the size to fit the wider columns on but this will eventually make it unreadable.

Honestly it seems pretty unusual to ever need to print the formulas, but if you do depending on their complexity manually adjusting the widths may be the only way.

 

[hlxbravo]

Thanks for that...will have a look later.