See all How-To Articles

How to Create a Cover Page in Excel & Google Sheets

This tutorial demonstrates how to create a cover page in Excel.

 

create cover page 1

 

Create Cover Page in Excel

The cover page is a great way to make your workbook more organized by putting all the general information on it. In Excel, there is no direct way to add a cover page but there is a workaround. To set a cover page just follow the next steps:

1. Add the sheet with all general information about the workbook.

 

create cover page 1

 

2. After the, (1) select the next sheet after the “cover” one (sheet 2) and in the Ribbon, (2) go to Page Layout and (3) click on Page Setup icon in the lower right corner.

 

create cover page 7

 

3. The Page Setup window will open. In First page number box (1) enter 1 and (2) press OK. After this step, sheet 2 will be marked as the first page of this workbook.

 

create cover page 3

 

4. To add page numbers, in the Ribbon (1) go to Insert and (2) choose Header & Footer.

 

create cover page 10

 

5. After that, (1) click on the Design tab and (2) select Page Number.

 

create cover page 11

 

As a result, the page numbers will be added.

To check this, in the Ribbon go to File and click on Print (or use CTRL + P shortcut).

 

create cover page 4

 

After that, under Settings (1) click on the Print Active Sheets (this is chosen by default) and (2) choose Print Entire Workbook.

 

create cover page 5

 

As a result, you will see that sheet 2 is numbered as page 1.

 

create cover page 6