See all How-To Articles

How to Add a Page Border in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on October 30, 2023

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.

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

add page border 1

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

add page border 2

  1. In the Ribbon, go to Home > Borders > Draw Border.

add page border 3

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

add page border 4

  1. To preview the result, in the Ribbon, go to File > Print.

add page border 5

Note: If you have multiple pages in your workbook, you need to manually draw each page border.
This adds a border around the page.

add page border 6

Draw a Page Border in Google Sheets

Portrait

In Google Sheets, there is no direct way to create a page border, but there is a workaround. Using default cell sizes, select a page-sized range and draw borders.

  1. To create a border for portrait orientation, select the range A1:N90.
  2. Then in the Menu, go to Borders > Outer borders.

add page border 9

As a result, the page border is created.

add page border 11

Landscape

  1. To create a page border for landscape orientation, select the range A1:Q59.
  2. In the Menu, go to Borders > 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 expands to page 2.

See all How-To Articles