No—not as a user-specific setting. In Excel for Microsoft 365, hiding a column hides it for everyone using that worksheet; to give different people different data, share separate files or data sources with appropriate permissions. For basic concealment, select the columns and choose Home > Format > Hide & Unhide > Hide Columns.
What hiding columns actually does
Hiding changes how a worksheet is displayed, not who can access its contents. A hidden column still exists in the workbook, and its values can remain part of formulas, charts, tables, and other workbook features. In a shared workbook, the hidden state is a worksheet setting, not a personal privacy setting that Excel applies according to each viewer’s identity.
To hide columns in Excel for Microsoft 365 on Windows, select the column letters at the top of the worksheet. To select several adjacent columns, drag across their letters; for separate columns, hold Ctrl while selecting each letter. Then choose Home > Format > Hide & Unhide > Hide Columns. You can also right-click a selected column heading and choose Hide.
To show the columns again, select the column headings on both sides of the hidden range, right-click, and choose Unhide. Alternatively, use Home > Format > Hide & Unhide > Unhide Columns. If the hidden columns are at the far left or right of the sheet, selecting the adjacent headings may be awkward; selecting the whole worksheet before choosing Unhide Columns can help, though it also reveals any other hidden columns.
Excel for the web also supports hiding and unhiding columns, although menu placement can differ slightly from the desktop app. In Excel for Mac, you can select the column headings, then use the context menu’s Hide or Unhide command. These actions still affect the worksheet’s display for other people, not just the person who performed them.
Can sheet protection keep columns hidden?
Protection can stop ordinary users from unhiding columns through the usual worksheet controls, but it does not turn hidden data into confidential data. On Windows, choose Review > Protect Sheet. In the protection dialog, leave the option to format columns cleared if you want to prevent users from changing column formatting, which includes hiding or unhiding columns. You can set a password, but protection is intended to control worksheet edits, not to secure sensitive information.
This can be useful for a presentation or an input form. For example, a template might contain calculation columns that most users should not casually alter. Hiding those columns and protecting the sheet can reduce accidental changes while leaving the rest of the worksheet usable, depending on the permissions you allow in the dialog.
It is not a reliable privacy barrier. Sheet protection does not provide a per-user rule, and it should not be treated as a way to keep confidential values secret from someone who has the workbook. A password on a protected sheet is different from encrypting a workbook to control whether it can be opened at all. Also, workbook-structure protection is not the same as column protection: it concerns actions such as hiding or unhiding worksheet tabs, not hiding columns within a sheet.
Why Excel does not offer per-user column hiding
A worksheet has one shared structure and display state. Excel does not include a setting such as show column G to one named person but hide it from another person opening the same worksheet. When multiple people collaborate in a workbook, a change to the shared worksheet can affect what others see. Features that separate some users’ sorting or filtering activity do not create access permissions for the underlying data.
This distinction matters because hiding often looks like removal. A coworker may not see a column while browsing the sheet, but the data is still in the file. If that person can access the workbook, you should assume that hiding alone does not prevent them from discovering information. Use hide and protect features for layout, convenience, or reducing accidental edits—not to decide who is entitled to see a value.
Safer ways to share different data with different people
If recipients genuinely need different information, give them access only to the information they are meant to receive. The most straightforward approach is to create separate workbooks containing only the appropriate data, then share each file with the relevant people. Store the files in OneDrive or SharePoint and set sharing permissions for each file or folder. Those permissions govern access to the file; they do not create different column permissions inside one workbook.
When making a restricted copy, do not simply hide unwanted columns, hide a worksheet, or protect the sheet. Create a copy that excludes the restricted information, and check what the copy contains before sharing it. Depending on the workbook, that can include hidden sheets, named ranges, formulas, charts, or other material that refers to data you intended to leave out. A clean export or a deliberately prepared workbook with only approved fields is safer than relying on visual concealment.
For recurring reports, consider preparing separate outputs from a trusted source rather than manually editing the same workbook each time. A report for a department might include department-level figures, while a management report includes broader totals. Keep the source file restricted to the people who need it, and share each output only with its intended audience. This also makes it easier to explain which version is authoritative.
Organizations with Microsoft 365 administration may have additional controls, such as sensitivity labels or rights-management features, depending on their licenses and configuration. These can help restrict access to a document by identity, but they are organization-level information-protection tools, not a feature that grants different people access to different columns in an ordinary Excel worksheet. Ask your Microsoft 365 administrator what is available and configured in your organization.
When a view or a separate report is enough
Sometimes the goal is simply to make a sheet easier to read. In that case, hiding columns is reasonable: for instance, a print-ready view might omit internal notes, or a data-entry sheet might tuck away helper calculations. If the information is not sensitive and everyone with workbook access is allowed to see it, a shared hidden-column state may be all you need.
Excel’s Sheet View feature is designed to let people work with their own sorting and filtering views without disrupting other collaborators’ views in supported workbooks. It can help when people need different ways to inspect a shared list. It is not an access-control system: someone who can access the workbook’s data can still access the data outside a particular filter or view. Do not use a personal view as a substitute for removing information a recipient must not receive.
If people need different columns for convenience but are all allowed to see the full dataset, consider giving them instructions to use their own filters or views, or provide separate presentation sheets. If they must not see certain fields, use separate files or a system that enforces permissions before the data reaches their workbook.
Common mistakes and practical checks
- Assuming hidden means deleted: Hidden columns remain part of the workbook. Unhide them before sharing if you need to inspect what is present, but do not rely on that check alone for sensitive-data control.
- Protecting a sheet and calling it secure: Sheet protection can prevent routine layout changes, but it does not provide dependable confidentiality or different permissions for different users.
- Sharing one workbook with different permission expectations: A file-level permission normally controls access to the file as a whole. It does not let you grant one person access to column A and another access to column B.
- Forgetting that the change is shared: If you hide a column in a shared worksheet, other collaborators may see the same hidden state. Coordinate display changes when people are working in the file at the same time.
- Sending a copy that still contains the data: Removing a column from view or hiding its sheet is not the same as preparing a clean, limited copy. Review the final file and its contents before distributing it.
A useful rule is to ask whether the requirement is about appearance or authorization. If it is about appearance, hiding columns or using a view may be suitable. If it is about authorization—who is allowed to know a value—do not put that value in a file that the person can access.
Frequently Asked Questions
Can I hide a column from one person but show it to everyone else?
No. Excel does not provide user-specific column visibility in a shared worksheet. Use separate files or a system with permissions that limit which data each person can access.
Can someone unhide columns in a shared workbook?
If the worksheet is not protected against formatting changes, a person with access can usually select the neighboring column headings and choose Unhide. Protection may block that ordinary command, but it does not make the hidden data confidential.
Does Protect Sheet hide data securely?
No. Protect Sheet helps control worksheet actions, such as editing cells or changing column formatting. It is not a dependable way to restrict access to sensitive information, and it does not set different permissions for different users.
Will hiding a column hide it for other collaborators?
Usually, yes: column hiding changes the worksheet’s shared display state. Excel’s personal Sheet Views can separate some sorting and filtering activity, but they do not prevent collaborators from accessing data in the workbook.
What is the safest way to share only selected columns?
Prepare a separate workbook or report that contains only the approved data, then share that file with the intended recipients using appropriate OneDrive, SharePoint, or organizational permissions. Do not include restricted fields and rely on hiding them.
Can I password-protect just one column?
Excel does not provide a per-column password or identity-based access rule. You can lock cells and protect a worksheet to limit editing, but for confidentiality, separate the data and control access to the resulting files or system.
Related
- Excel Data Validation From a Table Column: How to Set It Up
- Excel Data Validation: What Ignore Blank Really Means
- Excel Data Validation Default Value Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Solver: Find Numbers That Sum to a Value?Yes. Excel Solver can choose numbers from a list that add up to a target: give each number…
- Create a DAX Measure in Excel: Step-by-StepTo create a DAX measure in Excel for Microsoft 365 on Windows, add your data to the workbook’s…
- CSV File to Excel Converter: Convert Without Data LossTo convert a CSV file to an Excel workbook in Microsoft Excel for Microsoft 365 on Windows, select…
- Conditional Formatting Scatter Plots in ExcelExcel does not apply worksheet conditional-formatting rules directly to scatter-plot markers. To color points dynamically, split the data…
- How to Get Alternating Color Rows in Excel AutomaticallyTo get alternating color rows in Excel, select your data, choose Home > Format as Table, and pick…
- How to Make Every Other Line a Color in Excel QuicklyTo make every other line (row) a color in Excel, select your data rows, then choose Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.