Excel introductory

Resolved · Low Priority · Version 2007

Mon 28 Jul 2008, 16:27 Delegate Alaisdair said...

Alaisdair has attended:
Excel Introduction course
Excel Intermediate course

Excel introductory

When setting up a page as you are going along can you set an option to let you know if it will be too big to print onto a single page using a certain text size? Alternatively, do you have to format for printing after you have finished spreadsheet?

Wed 30 Jul 2008, 14:27 Trainer Amanda said...

RE: Excel introductory

Hello Alaisdair

Thank you for your question; and welcome to the forum.

If you go into Print Preview, and then exit it, you will see dotted lines on your spreadsheet which show where the edges of the pages will fall when you print.

If your spreadsheet goes over one page, you should be able to see this on your screen.

You can change the scaling in the Page Setup features (File - Page Setup - Page) in order to fit more on one page, however this may affect readability when the spreadsheet is printed out.

Amanda

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips

Excel introductory

Excel introductory

RE: Excel introductory

Excel articles

Excel tip:

Creating charts in Excel 2010