How To Add A Page Border In Excel & Google Sheets

Home » How To Add Border In Excel » How To Add A Page Border In Excel & Google Sheets

Maybe your like

See all How-To Articles

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

Try our AI Formula Generator

Generate

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.

AI Formula Generator

Try for Free

AI Tools

  • Excel Help Bot
  • Formula Generator
  • Formula Explainer
  • VBA Code Generator
  • VBA Code Commenter
  • Excel Template Generator

See all How-To Articles

← Find and Replace Multiple Values in Excel & Google SheetsHow to Limit / Restrict Cell Values in Excel & Google Sheets →

Try our AI Formula Generator

Generate =SUMIF(A:A, "Q1", B:B)

Tag » How To Add Border In Excel