Welcome to Excelling with Excel

Page Setup

Page Setup 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 Setup 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.

You find Page Setup by going to the File Menu and selecting Page Setup. When you select Page Setup, a dialog box appears with four tabs at the top: page, margins, header/footer and sheet.

The Page 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 Header/Footer Tab

• 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 arrowhead at the end of the blank area under header.
• 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.
• NOTE: all your projects will have a header

The Sheet Tab

• Concentrate on the Print section of this tab for now.
• 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