• 6 hours
  • Easy

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 9/1/22

Set up the Page layout

Set up the page layout for your file
Set up the page layout for your file

Now that you know how to adjust cells and tabs in Excel to your own specific needs, we’re going to look at the page layout.

Hide Gridlines

The gridlines you see on screen don’t appear when you print out the document. But to make your workbook more readable, you might want to hide the gridlines on screen as well.

It’s super simple to hide gridlines in an Excel tab:

  • Click on the View tab.

  • In the Show group, uncheck Gridlines.

As you've probably already worked out, if you want to show the gridlines again after hiding them, you do this in the same way by checking the Gridlines box.

The gridlines have been hidden
The gridlines have been hidden

When the gridlines are hidden, you can no longer see the data boundaries for your worksheet. This could make it more difficult to read.

Let’s add some borders to make things clear:

  • Select the range of cells from B3 to E9.

  • Click on the Home tab.

  • In the Font group, click on the Borders icon .

  • Select All borders.

Now you’ve added borders!
Now you’ve added borders!

Freeze Panes

Freezing panes is important when you're working on an Excel file that contains lots of rows or columns.

To avoid this problem, you can “freeze” panes, or keep the top row on screen visible even if you scroll down to the rows below.

To freeze panes:

  • Click on the View tab.

  • In the Window group, click on the Freeze Panes icon.

  • Select Freeze Top Row.

To unfreeze panes:

  • Click on the View tab.

  • In the Window group, click on the Freeze Panes icon.

  • Select Unfreeze Panes.

Wrap Cell Text

If you have lots of content within a cell, you can adjust the cell width to match the contents, as we saw in the chapter on rows and columns. But you could also wrap the text.

Here’s what that looks like (in this example, cells A1 and H1):

Here we’ve wrapped the text in cells A1 and H1
Here we’ve wrapped the text in cells A1 and H1

To wrap the text within a cell:

  • Select the cells whose contents you’d like to wrap.

  • Click on the Home tab.

  • In the Alignment group, click on the Wrap Text icon.

Watch the Video Tutorial!

Watch a step-by-step recap of everything described in this chapter in the tutorial below:

Print Your Workbook

Now you know how to set up the page in your file, you’ll be able to print it.

Print a Workbook

  • Click on the File tab.

  • On the sidebar, click on the Print command.

  • Click on the Print icon to trigger the print.

Print Titles

If your file is very big with lots of rows, it will be printed over several pages.

The column headings will be printed on the first page, but not on any of the following pages, which will make it difficult to read.

To avoid this, you can Print titles, which means repeat the column headings at the top of each page.

To print titles:

  • Click on the Page Layout tab.

  • In the Page Setup group, click on the Print titles icon.

  • In the Rows to repeat at top section, select the row in your worksheet that contains the headings.

  • Then click OK to confirm.

Select the title row to be repeated
Select the title row to be repeated
Add Page Numbers

When you want to print a file with several pages, you can ask Excel to add page numbers.

To do this, you can change the page footer.

To change the page footer:

  • Click on the Page Layout tab.

  • Click on the Page Setup button.

Click on the Page Setup button
Click on the Page Setup button
  • Go to the Page Setup dialog box.

  • Click on the Header/Footer tab.

  • In the Footer section, select Page 1.

Select Page 1 in the Footer section
Select Page 1 in the Footer section

Now, all your printed pages will be numbered.

Define a Print Area

When you’re working with a large file, you won’t always need to print the whole workbook. You can choose to print just part of it.

To do this, you can define a Print area.

To define a print area:

  • Select the area of the workbook that you’d like to print.

  • Click on the Page Layout tab.

  • In the Page Setup group, click on the Print Area icon .

  • Select Set Print Area.

The print area is outlined in black. This means that the range from B1 to E44 will be printed
The print area is outlined in black. This means that the range from B1 to E44 will be printed

You’ll see that a black border has appeared to show you that a print area has been defined.

If you want to remove the print area:

  • Click on the Page Layout tab.

  • In the Page Setup group, click on the Print Area icon. 

  • Select Clear Print Area.

Watch the Video Tutorial!

Watch a step-by-step recap of everything described in this chapter in the tutorial below:

Let’s Recap!

  • There are many page layout options within Excel. You can hide the gridlines, freeze panes and wrap text when a cell’s contents are too long to fit in the cell.

  • You can use different options to improve the look of your printouts, such as repeat headers over several pages, add page numbers and define a print area.

You now know how to set up your page layout and print your workbook. In the next chapter, we’re going to see how to format the page automatically using conditional formatting.

Ever considered an OpenClassrooms diploma?
  • Up to 100% of your training program funded
  • Flexible start date
  • Career-focused projects
  • Individual mentoring
Find the training program and funding option that suits you best
Example of certificate of achievement
Example of certificate of achievement