Hide and Password-Protect Columns in Excel

How-to basics · Updated November 21, 2026

To hide a column in Excel for Microsoft 365 on Windows, select its letter, then choose Home > Format > Hide & Unhide > Hide Columns. To stop ordinary users from unhiding it, protect the worksheet with a password using Review > Protect Sheet, and leave Format columns unchecked. This discourages changes; it does not make the column’s contents confidential.

What Hiding and Protecting a Column Actually Does

Excel does not have a separate password setting for an individual column. Instead, you hide the column and protect the worksheet that contains it. Hiding changes what is displayed; worksheet protection controls certain actions on that sheet, including whether users can format columns and reveal hidden ones.

Protection applies to a worksheet, not just the column you selected. It can also restrict actions such as editing locked cells, inserting rows, or sorting, depending on which permissions you allow. This is useful for preventing accidental changes to a report or template, but it is not the same as securing a file against someone determined to inspect it.

For example, you might hide an internal cost column in a quote template and protect the sheet so a customer-facing user cannot casually unhide or alter it. That is a convenience and editing control. It should not be used to conceal confidential costs from someone who has access to the workbook.

Hide a Column and Protect the Worksheet

First hide the column, then protect the sheet. In Excel for Microsoft 365 on Windows:

  1. Open the worksheet and select the column by clicking its letter at the top. To select several neighboring columns, drag across their letters. To select separate columns, hold Ctrl while clicking each letter.
  2. Choose Home > Format > Hide & Unhide > Hide Columns. You can also right-click a selected column letter and choose Hide.
  3. Open the Review tab and choose Protect Sheet.
  4. In the Protect Sheet dialog box, keep Protect worksheet and contents of locked cells selected. Enter a password if you want password-based unprotection.
  5. Review the allowed actions. For the usual goal of keeping hidden columns hidden, leave Format columns cleared. Select other permissions only if users need them, then choose OK.
  6. If prompted, enter the password again to confirm it. Save the workbook and test the result in a copy before distributing it.

Cell locking is related but separate. Most cells are marked as locked by default, but that setting only takes effect when the worksheet is protected. If users need to edit input cells, select those cells before protecting the sheet, open Format Cells, go to Protection, and clear Locked. Then protect the sheet. This lets you keep formula or label cells protected while leaving designated input areas editable.

Choose the Protection Permissions Carefully

The Protect Sheet dialog box lets you decide which actions remain available. If Format columns is allowed, a user may be able to change column formatting, including unhiding a hidden column. Clear that permission when keeping columns hidden is the goal. Other permissions are independent: for example, allowing users to select cells does not automatically let them change a hidden column’s visibility.

Think about the full task users need to perform before turning on protection. A data-entry sheet might allow selecting unlocked cells, sorting, or using AutoFilter, while still preventing changes to locked cells and column formatting. A static report may need fewer permissions. Allowing extra actions can make a sheet easier to use, but test that the specific actions you want to block are still blocked.

Protection can also affect routine work. Users may be unable to insert or delete columns, change widths, or perform other formatting actions if those permissions are not enabled. If a protected sheet has to be maintained regularly, document the password and the intended permissions for the people responsible for updates.

How to Unhide the Column Later

To reveal a column yourself, first remove worksheet protection. On the Review tab, choose Unprotect Sheet and enter the password if Excel asks for it. Then select the column headers on both sides of the hidden column and choose Home > Format > Hide & Unhide > Unhide Columns. You can also right-click the selected headers and choose Unhide.

If the first column, A, is hidden, there may be no visible header immediately to its left. Click the Select All button at the intersection of the row numbers and column letters, then use Home > Format > Hide & Unhide > Unhide Columns. You can also enter a cell reference such as A1 in the Name Box to select a location, then use the ribbon’s unhide command.

When a sheet is protected, Excel may disable the command or refuse to change column visibility. That is expected if the sheet does not permit column formatting. Unprotect the sheet first; if you do not know the password, ask the workbook owner or the person who set it rather than assuming the hidden column is damaged.

Hidden Formulas Are a Different Setting

Hiding a column conceals its cells from the normal worksheet view, but it does not hide a formula merely because the formula is in that column. Conversely, Excel has a separate Hidden setting for formulas in selected cells. To use it, select the formula cells, open Format Cells, choose Protection, and select Hidden. Then protect the worksheet. The formula is hidden from the formula bar when a protected sheet is viewed.

This setting also is not a confidentiality feature. It is intended to keep formulas out of ordinary view while someone works in a sheet. A formula’s result may still be visible in a cell, and worksheet protection should not be treated as a secure way to store business logic or sensitive information. Hiding a row or column and hiding a formula are separate choices, and you can use either one without the other.

Worksheet Passwords Versus File Encryption

A worksheet-protection password is primarily an editing barrier. It can stop casual users from changing protected cells or using restricted sheet commands, but Microsoft does not present worksheet protection as a way to secure sensitive data. Someone with access to the workbook may still be able to inspect its contents through other means, and protection should not be relied on against deliberate access.

If you need to limit who can open the workbook, use file-level encryption instead. In Excel for Microsoft 365 on Windows, choose File > Info > Protect Workbook > Encrypt with Password, enter a password, and confirm it. This protects access to the workbook file, rather than just restricting actions on one sheet. Keep the password somewhere safe: losing an encryption password can prevent you from opening the file.

Use file encryption for sensitive information and share the password through an appropriate separate channel. If particular people should not receive certain data at all, the safer choice is usually to remove that data from the copy you share, rather than leave it in a hidden column. A hidden column remains part of the workbook.

Common Problems and Misunderstandings

  • The column is still visible or can be unhidden. Check that the worksheet is protected and that Format columns is not allowed. Also check whether you protected the correct sheet; protection is applied one worksheet at a time.
  • You cannot edit cells after protecting the sheet. That is normal for locked cells. Before protecting the sheet, unlock the cells users should edit through Format Cells > Protection > Locked.
  • The password does not work. Worksheet passwords are case-sensitive. Check capitalization and keyboard layout, and make sure you are using the password for this sheet rather than a workbook-opening password.
  • Users can see the information elsewhere. A hidden column may still feed formulas, charts, or other worksheets. If data must not be disclosed, remove it from the shared workbook and check dependent sheets and charts.
  • The hide command is unavailable. The sheet may be protected. Unprotect it first, or ask the owner to adjust the protection permissions.

Before you send a protected workbook, keep an editable backup and test the recipient’s workflow. Try editing an intended input cell, attempting to unhide the column, and saving and reopening the file. This catches permission problems without risking your original working copy.

Windows, Mac, and Excel for the Web

The ribbon steps above are for Excel for Microsoft 365 on Windows. Excel for Mac also has worksheet protection and column hide/unhide commands, though the dialog layout and ribbon arrangement can differ. Look for Protect Sheet on the Review tab, and for Hide & Unhide under the Home tab’s formatting controls. Right-clicking a column header is another way to find Hide and Unhide.

Excel for the web can hide columns and provides worksheet-protection controls, but some protection and workbook-management options differ from the desktop app and can change as Microsoft updates the service. If you need to set or verify a particular password-protection setup, open the workbook in the desktop app and confirm the permissions there. Menus can also vary slightly by update or screen size.

Frequently Asked Questions

Can I password-protect just one column in Excel?
Not as an independent column password. Hide the column and protect its worksheet, leaving Format columns disabled to prevent ordinary unhiding. The protection affects the whole worksheet, so choose the other permissions with the rest of the sheet in mind.

Can someone see a hidden column in a protected sheet?
Protection can stop normal users from unhiding the column through Excel’s sheet commands, but it does not make the data secret. If the workbook contains information a recipient should not see, remove that information from the file you share.

Does hiding a column hide its formulas?
No. Hiding a column hides the cells from the standard worksheet view. To hide formulas from the formula bar, set the cells’ Hidden property in Format Cells > Protection and then protect the worksheet.

How do I unhide a column when the sheet is protected?
Choose Review > Unprotect Sheet and enter the sheet password. After protection is removed, select the neighboring column headers and choose Home > Format > Hide & Unhide > Unhide Columns.

What if I forget the worksheet password?
Ask the workbook owner or whoever applied protection for the password. Worksheet protection is not the same as file encryption, but you should not rely on unofficial bypass methods for important workbooks. Keep a documented password and an authorized unprotected backup when appropriate.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.