Spreadsheets Page Setup And Printing

33 %
67 %
Information about Spreadsheets Page Setup And Printing
Education

Published on November 3, 2008

Author: MoreThanMaths

Source: slideshare.net

Description

Step by step guide to some of the options when printing in Excel.

Includes print preview, page breaks, page setup and formula view

Learn how to: See what your printed spreadsheet will look like Change margins, page layouts and headings Put in page breaks Print the spreadsheet showing the formulae that you used

See what your printed spreadsheet will look like

Change margins, page layouts and headings

Put in page breaks

Print the spreadsheet showing the formulae that you used

Print Preview It’s always a good idea to see what your print out will look like before you actually print it. Then you can avoid wasting paper and printer ink. You can do this by using Print Preview

It’s always a good idea to see what your print out will look like before you actually print it.

Then you can avoid wasting paper and printer ink.

You can do this by using Print Preview

Print Preview: Just click File, then choose Print Preview

Print Preview: Now you can see if your print out looks OK. If it doesn’t, you will need to change some things before you print.

Page Breaks Excel often puts half of a table on one page and the other half on another page. Not much good! You can decide where you want one page to stop and a new page to start using Page Breaks

Excel often puts half of a table on one page and the other half on another page. Not much good!

You can decide where you want one page to stop and a new page to start using Page Breaks

Page Breaks: After you have done a Print Preview, a dotty line like this shows your where one page ends and the next one starts.

Page Breaks : If I select this cell and click on Insert, then choose Page Break my page will start at the start of my table. Much more sensible!

Page Setup You can change the way that your print out will look by using Page Setup You can use Page Setup to Set the paper size Choose portrait or landscape Add page headings And much more!

You can change the way that your print out will look by using Page Setup

You can use Page Setup to

Set the paper size

Choose portrait or landscape

Add page headings

And much more!

Using Page Setup: 1. Click on File and then choose Page Setup

Using Page Setup: You will see this dialogue box. It has several tabs, each one takes you to a different section.

Using Page Setup: The page tab Choose portrait or landscape Choose a paper size

Using Page Setup: The page tab You can scale your work to make it all fit onto one page, but be careful – you might end up with very small writing!

Using Page Setup: The margins tab Choose the margins you want for your paper Print in the centre of the paper

Using Page Setup: The header/footer tab Choose Custom Header

Using Page Setup: Choose what you want in your heading. It’s a good idea to type your name as a heading!

Using Page Setup: Choose what to print. You might want to tick this to print the gridlines. The sheet tab

Printing Out Your Formulas You can show someone what calculations your spreadsheet is doing. Watch out – this will change all of your column widths, but DON’T PANIC – they will change back!

You can show someone what calculations your spreadsheet is doing.

Watch out – this will change all of your column widths, but DON’T PANIC – they will change back!

Printing Out Your Formulas : Just click Tools, then choose Options

Printing Out Your Formulas : This dialogue box will appear. Click to put a tick (check) next to formulas. Then Click OK

Printing Out Your Formulas : Now you can see the formulas. This is what will print out DON’T PANIC about the column widths! Just leave them as they are.

Printing Out Your Formulas : To change back, just click Tools, then choose Options. Then get rid of the tick next to formulas. Easy!

Summary: Use Print Preview before you print your work. Choose File -> Print Preview Use Page Setup to change the way that your work looks when you print it. Choose File -> Page Setup To display your calculations, choose Tools -> Options and click on Formulas

Use Print Preview before you print your work. Choose File -> Print Preview

Use Page Setup to change the way that your work looks when you print it.

Choose File -> Page Setup

To display your calculations, choose

Tools -> Options and click on Formulas

Add a comment

Related presentations

Related pages

Excel - Page setup and printing - ULearnOffice

Excel - Page setup and printing. Introduction Page layout Printing area Printing ... From the File menu, select the Page setup option. Under the ...
Read more

Make a worksheet fit the printed page - Excel

Make a worksheet fit the printed page. Applies To: ... To preview the worksheet before printing, ... in the Page Setup group, ...
Read more

Excel 2003 Printing Options - About.com Tech

Using the Page Setup Dialog Box . The page tab in the Page Setup Dialog Box has three areas of printing options. Orientation – Allows you to ...
Read more

Prepare a worksheet for printing - Excel - support.office.com

Prepare a worksheet for printing. Applies To: ... Top of Page. Printing all or part of a worksheet. ... (Page Layout tab, Page Setup group).
Read more

Excel 2007 Spreadsheet Print Options - About.com Tech

This tutorial on Excel spreadsheet print options ... Page Setup – Opens the Page ... Page order – Changes the order for printing pages on a ...
Read more

Excel Tips: 5 Tips for Printing Excel Spreadsheets - Page 1

5 tips for printing Excel spreadsheets. So you've made an Excel workbook full of data. ... When you insert a page break into your worksheet, ...
Read more

Printing Excel Spreadsheets - Colorado State University ...

Printing Excel spreadsheets ... The Page Setup command is in the ... Use the Print Preview button to preview you scaled spreadsheet before printing . ...
Read more

How to set the Printing Settings - Apache OpenOffice

How to set the Printing Settings ... In the page preview ... To display a break page preview before printing your sheet:
Read more

How to set page setup attributes for more than one sheet

To set page setup attributes for a group of Excel worksheets, use one of the following methods. Method 1: Change a group of worksheets To apply page setup ...
Read more