Related topics
Password protect workbooks and worksheets
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Password protect workbooks and worksheets

Password protect

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Add a password to protect worksheets or your entire workbook and control whether others can open or make changes to them.

You can add headers to the top and footers to the bottom of a worksheet.

When you print the worksheet, the headers and footers also print.

For example, you might create a header with the file path and a footer with page numbers.

Headers and footers display only in Page Layout view and on printed pages.

Select the worksheet you want to add a header or footer to. Click the Insert tab, and click Header & Footer.

This displays the worksheet in Page Layout view.

The Header & Footer Tools Design tab appears, and by default, the cursor is in the center section of the header.

I’m selecting the left section. I want to add the file path to it, so I click the File Path button.

I click anywhere else on the worksheet and the file path displays in the left section of the header on all pages.

To add a footer, scroll to the bottom of the page, select the section of the footer you want to add something to.

On the Design tab, click an element, such as Page Number,

click anywhere else on the worksheet, and page numbers now display in the footer.

There are other elements on the Design tab, check them out.

You can also just type information in a header or footer.

Select the section you want to add text to and type your text.

When you’re done, you might want to return to Normal page view, to have more room to work on your worksheet.

Click the worksheet, click the View tab, and click the Normal button.

Up next, page numbering in depth.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!