See all How-To Articles

How to Add a Page Border in Excel & Google Sheets

This tutorial demonstrates how to add a page border in Excel and Google Sheets.

 

add page border 8

 

Draw a Page Border

To make your document look more professional, you can add a border around the page. To achieve that, follow these steps:

1. In the Ribbon, go to View > Page Break Preview.

 

add page border 1

 

2. Then, resize the page area to fit page dimensions by dragging the page borders.

 

add page border 2

 

3. After that, in the Ribbon, (1) go to Home, (2) click on Borders icon, and from the list (3) choose Draw Border.

 

add page border 3

 

4. Draw the border around the page margins (blue lines).

 

add page border 4

 

5. When done with the drawing, to preview the result in the Ribbon go to File and click on Print.

 

add page border 5

 

Note: If you have multiple pages in your workbook, you need to manually draw each page border.

As a result, the border around the page is added.

 

add page border 6

 

Draw a Page Border in Google Sheets

In Google Sheets, there is no direct way to create a page border, but there is a workaround. To do that, follow these steps:

To create a border for portrait orientation, (1) select the range A1:N90. Then in the Menu, (2) click on the Borders icon and (3) select the Outer borders.

 

add page border 9

 

As a result, the page border is created.

 

add page border 11

 

To create a page border for landscape orientation, select the range A1:Q59 and in the Menu click on the Borders icon and select the Outer borders.

 

add page border 10

 

Note: This method works only with default cell sizes. If you change the row height or column width it will expand to page two.