Welcome to Excelling with Excel 2007

Page Layout

Page Layout is one of the first places to visit when doing an Excel spreadsheet and one of the last when you go to print a document.
Page Layout lets you set paper size, reduce the printing area, add headers and footers and print your spreadsheet with lines and column headings or without them.

The Orientation Tab

• You can select orientation: portrait (up and down) or landscape
• Scaling allows you to reduce the size of the spreadsheet. Why would you want to do that? What if you wanted to see if you could print spreadsheet data on one sheet and when you look at your spreadsheet in print preview, it shows two pages - you could try scaling your spreadsheet. I find 75% does a good job, the information can still be read. Under 75% is iffy.
• You can also select the paper size. There is an arrowhead at the end of the words letter and when you click on that arrowhead paper size selections appear. By choosing another paper size can also help print spreadsheet data on one piece of paper.

The Insert Tab - Header & Footer Button

• This is where you can have a header placed on your spreadsheet. Header information can be the name of the project, your name and the date.
• You can explore the header options by clicking on the Header button.
• You can also create a custom header. Custom headers are nice as the offer more flexibility. The custom header is divided into three areas where you could put your name, the date, the name of the project and so on. Excel will place you in the center header as the default, click to the left of it for the left header side & right for the right header side.
• Click on the Header or Footer button for a dropdown menu of custom choices for each.
• NOTE: all your projects will have a header

The Page Setup selection

• Concentrate on the Print section of this tab for now. Click onthe arrow in the right corner.
• You can print a spreadsheet showing the gridlines (those are all the lines you see on the spreadsheet) by clicking in the box beside gridlines.This can be a busy looking spreadsheet and not easy to read.
• You can print a spreadsheet showing the column headings (A-Z+) and rows by clicking in the box beside row and column headings. This may be a busy looking spreadsheet too.

Moving on to entering data into Excel