How to View Header in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on August 21, 2023

This tutorial demonstrates how to view the header in Excel and Google Sheets.

 

viewheader intro

 

In Excel, you can view the header of your document by changing the view to Page Layout or by going to Print Preview. Page Layout view allows you to edit and format your header whereas Print Preview only allows you to view the header.

(If you don’t already have a header, see Insert Headers and Footers.)

Page Layout View

To view the header of your document, in the Ribbon, go to View > Page Layout.

 

header and footer 1

 

OR

In the bottom-right corner of your screen there are three view buttons. Click on the middle button – Page Layout.

 

viewheader page layout button

 

The worksheet is now shown on the screen in Page Layout view.

Print Preview

In the Ribbon, select File > Print to show the spreadsheet in Print Preview.

 

viewheader printpreview

 

OR

Alternatively, click on the Print Preview and Print icon in your quick access menu above the Ribbon.

 

viewheader quick menu

 

If you don’t have the Print Preview and Print icon in your quick access menu, click on the drop-down arrow to the right of the quick access menu and tick Print Preview and Print.

 

viewheader quick access customize

 

View Header in Google Sheets

In the Menu, go to File > Print to open the printer settings menu for your document.

 

remove header insert footer 18

 

OR

Alternatively, use the keyboard shortcut: CTRL + P.

 

viewheader gs header

 

If the document has a header, it is shown on the screen.

AI Formula Generator

Try for Free

See all How-To Articles