Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Page Layout Tab

EXCEL 2010 PAGE LAYOUT RIBBON

Page Setup

EXCEL 2010 PAGE SETUP GROUP

In the Page Setup section, select the Margins drop-down menu.

 

EXCEL 2010 PAGE SETUP MARGINS

Here you will see a gallery showing a number of margin options (shown in the image to the right). Click one of the options and it will be applied to your document.

If none of the gallery’s options are satisfactory, select the Custom Margins option.

The Page Setup dialog box opens with the Margins tab displayed. Use the options in the Page Setup dialog box to adjust the margins to your satisfaction. When you are finished with your selections, click OK.

 

EXCEL 2010 PAGE SETUP ORIENTATION


Select the Orientation drop-down menu to change your document to Portrait or Landscape.

 

EXCEL 2010 PAGE SETUP PAPER SIZES



To choose a paper size for the current section, select the Size drop-down menu.

Make your selection from the various options given (as shown in the image to the right). Your current section will now be updated to the new paper size.

To apply a specific paper size to all sections in the document, click More Paper Sizes at the bottom of the drop-down menu.

The Page Setup dialog box will appear with the Page tab showing. Choose your paper size and select OK. All sections will now be updated with your selection.

EXCEL 2010 PAGE SETUP PRINT AREA

When printing your worksheet, Excel has the option to select the print area. First, select the area of your worksheet that you would like to print. Next, select the Print area drop-down menu found in the Page Setup section of the Page Layout tab. Select Set Print Area. You are now ready to print the selected area.

Select Clear Print Area to undo your print selection.

EXCEL 2010 PAGE SETUP PAGE BREAK

Specify where a new page will begin by inserting a Page Break.

First, do one of the following:

·         To insert a vertical page break, select the row below where you want to insert the page break.

·         To insert a horizontal page break, select the column to the right of where you want to insert the page break.

Select the Breaks drop-down menu from the Page Setup section of the Page Layout tab. Select Insert Page Break.

To move your page break, go to the View tab, in the Workbook Views section and select Page Break Preview. Your page breaks will appear as solid blue lines (as shown in the image below). Click on the page break and drag it to the desired location.

EXCEL 2010 PAGE SETUP PAGE BREAK PREVIEW

Stay in the Page Break Preview view to delete or reset your page breaks. To delete a page break do one of the following:

·         To delete a vertical page break, select the column to the right of the page break that you want to delete.

·         To delete a horizontal page break, select the row below the page break that you want to delete.

Then select Breaks in the Page Setup section of the Page Layout tab. Click on Remove Page Break. To clear all page breaks, select Reset All Page Breaks from the Breaks drop-down menu.

You can add a graphic image to the background of cells in your worksheet. Keep in mind, you want this image to be very light in color so your data is still legible over the image.  Also, this image is only seen on the computer and won’t be visible when you print your document.

On the Page Layout tab in the Page Setup section, select Background. The Sheet Background dialog box will appear. Open the folder that contains your background image you want to use, click its graphic file icon and then click Insert. As shown in the image below, your background graphic will now be in your document.

EXCEL 2010 PAGE SETUP BACKGROUND

Notice in the Page Setup section that the Background button has now changed to Delete Background. To remove a background, simply select the Delete Background button.

EXCEL 2010 PAGE SETUP PRINT TITLES

If you have a document that spans more than one page, it is helpful to repeat your headings throughout each page so you know what the data represents.  For example in the image above, we have our months, January through December, listed as our column headings. If our document goes to a 2nd, 3rd or more pages, it is helpful to see what month’s data we are viewing.

Let’s start by selecting Print Titles from the Page Setup section of the Page Layout tab. The Page Setup dialog box will appear. In the Sheet tab select the Collapse Popup Window button to the right of Rows to repeat at top.

This will take you back to your work sheet, where we will select rows 1 through 4 (as shown in the image below). When finished selecting your rows, select the Collapse Dialog button again. Select OK.

EXCEL 2010 PAGE SETUP PRINT TITLES

Now, each of our pages will start with rows 1 through 4 when printing.

Next Tutorial


This concludes the Page Setup tutorial.
Click next to continue to the Excel 2010 Scale to Fit tutorial.