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.

See all How-To Articles