How to Hide Columns in Excel on iPad Without Deleting Data

To hide a column in Excel on iPad, tap its letter at the top of the worksheet to select it, then choose Home > Format > Hide & Unhide > Hide Columns. The column disappears from view, but its contents remain in the workbook and can be shown again later. You need the Excel app and an editable workbook; hiding a column does not protect its information from other people.

What You’ll Need

An iPad with the Microsoft Excel app installed and a workbook open.
Permission to edit the workbook. If it is read-only or protected, Excel may not let you change the sheet.
The worksheet containing the column or columns you want to hide. If the file is stored online, an internet connection may be needed to sync the change.

Step-by-Step

Open the right worksheet. Open the workbook in Excel and tap the worksheet tab that contains the information. If you cannot see the tab you need, use the sheet-tab navigation controls at the bottom of the screen to move through the workbook. Check that you are on the intended sheet before changing its layout; hiding a column affects only the active worksheet.
Find the column letter. Look at the letters across the top of the grid: A, B, C, and so on. These are column headings. If you want to hide a column with a particular heading, find that heading in the cells, then trace straight up to its letter. For example, if “Internal notes” is in column F, select F rather than only tapping the cell that contains the heading.
Select the whole column. Tap the column letter once. The full column should become selected, usually with a colored highlight or border. Make sure the selection covers the entire column rather than one cell. If you tap a cell by mistake, tap the letter at the top again. To select a run of neighboring columns, touch the first column letter and drag across the headings to the last one. For instance, select D through F to hide all three together. If dragging is awkward, hide each column separately.
Open the formatting controls. With the column selected, tap the Home tab on the ribbon if it is not already active. Tap Format, then look for Hide & Unhide. Depending on your Excel app version and screen width, you may need to scroll through the Home ribbon or open its overflow controls to find Format. Keep the column selected while you open the menu.
Hide the selected column. Tap Hide Columns. The column letter and cells should disappear, and the letters on either side will sit next to each other. If you selected several adjacent columns, all of them should disappear. Excel does not erase their values, formulas, or formatting; it changes whether those columns are displayed.
Check the result. Look at the column letters on both sides of the gap. If the letters jump from, for example, C to G, columns D through F are hidden. If the letters remain in sequence, the command may not have run or the wrong range may have been selected. Undo immediately with the Undo button if you hid the wrong columns, or repeat the selection and use Unhide.
Save or wait for sync. If the workbook is saved in OneDrive or SharePoint, allow Excel time to sync the layout change. For a locally stored file, use the app’s save controls if shown and confirm the workbook is not displaying a pending-save indicator. If other people share the workbook, the hidden state may be visible to them too.

Alternative selection menu: In some Excel for iPad versions, tapping a selected column heading or pressing and holding it opens a shortcut menu with a Hide option. You can use that option if it appears. The ribbon command is the more consistent route across app layouts. Avoid choosing Delete: that removes the column instead of merely hiding it.

To unhide a column later: Select the visible column headings on both sides of the hidden area. For example, if the letters jump from C to F, select columns C through F by dragging across their headings. Open Home > Format > Hide & Unhide and tap Unhide Columns. Include the neighboring visible columns in your selection; selecting only a cell inside the hidden column is not possible because the column is not displayed. If columns at the edge of the sheet are hidden and you cannot select both sides, tap the worksheet’s top-left Select All corner, where the row and column headings meet, then use Unhide Columns. This reveals hidden columns throughout that sheet, so use it when showing all of them is acceptable.

Common Mistakes

Selecting a cell instead of its column: Tapping a cell highlights only that cell. Tap the letter above it to select the complete column before choosing Hide Columns.
Deleting instead of hiding: Delete removes the column and shifts other data. Hide Columns only changes visibility. If you deleted a column accidentally, use Undo promptly; do not save and continue working if you need to restore the original layout.
Hiding the wrong worksheet’s column: Column letters repeat on every worksheet. Confirm the active sheet tab and the heading in the cells before hiding anything.
Thinking hidden means private: Hiding is a presentation choice, not a security feature. Anyone with sufficient access can unhide the column, and formulas may still refer to its contents. Do not use hiding to conceal passwords, personal data, or other sensitive information.
Assuming the data was removed: A hidden column will not appear in the grid, which can make it look as if values are missing. Check whether the column letters skip a letter before entering the data again; otherwise you could create duplicates.

Tips

Hide only what improves the view. Hiding helper calculations, reference codes, or rarely needed details can make a worksheet easier to read on an iPad’s smaller screen. Keep columns that people need for routine decisions visible.
Record what you hid. If the workbook has many columns, add a note in a visible cell or use a clear worksheet label to tell collaborators that certain fields are hidden. This can prevent someone from assuming the data was deleted.
Hide multiple adjacent columns in one action. Selecting a continuous block and hiding it is quicker than repeating the command. For columns that are separated by visible columns, hide each one or each separate block individually.
Use Freeze Panes for a different problem. If you want a column to remain visible while you scroll sideways, hiding it is the opposite of what you need. Look under the View tab for Freeze Panes options; the available choices depend on the selection and app version.
Remember that the change belongs to the sheet. A hidden column remains hidden when the workbook is reopened and may appear hidden to collaborators viewing the same workbook. If you need a clean view for a specific task but do not want to alter a shared layout, consider making a separate copy first.
Check what you share or print. Hidden columns are not normally shown in the worksheet view, but hiding is not a guarantee that information is excluded from every chart, export, or other use of the workbook. Review the actual output and its settings before sharing it.

Troubleshooting

Hide Columns is missing or dimmed: First tap a column letter, not a cell, and check that the workbook is editable. If the sheet is protected or you only have viewing permission, ask the owner for edit access or for the sheet to be unprotected. Also check that the Home tab is open and that you have scrolled far enough through its controls to see Format. Menu placement can differ between Excel app versions and screen sizes.

The column did not disappear: Confirm that the entire column is selected and tap Hide Columns again. On a touch screen, it is easy to select a cell or drag the grid instead of selecting the headings. Check the letters at the top after applying the command. If the letters are consecutive, you may have selected a different column than intended; undo and try again using the column heading.

You cannot find or select a hidden column: Look for a jump in the column letters. Select the visible headings on both sides of that jump and use Unhide Columns. If the hidden column is at the far left or right, use Select All and Unhide Columns instead. Be aware that Select All can reveal other hidden columns on the same sheet as well.

The workbook looks different on another device: Make sure the iPad has finished syncing and that everyone is opening the same workbook, not a downloaded copy. Hidden columns are part of the worksheet’s layout, so collaborators with access may see the same hidden state. If the workbook is shared, tell collaborators what changed and ask them to refresh or reopen it if the update has not appeared.

The menu names do not match: Update Excel from the App Store if an update is available, then reopen the workbook. Some builds expose Hide through a shortcut menu on the selected column heading, while others make the Home ribbon route easier to find. The key is to select the column heading first and choose Hide, not Delete.

Frequently Asked Questions

Can I hide more than one column at a time on an iPad?
Yes. Select a continuous range by dragging across its column letters, then choose Hide Columns. For columns that are not next to each other, repeat the process for each separate column or block.

Will hiding a column delete its data or change formulas?
No. Hiding changes the column’s visibility, not its contents. Formulas can still refer to cells in hidden columns, and those cells remain part of the workbook.

How do I unhide a column in Excel on iPad?
Select the visible column headings on either side of the hidden column, then choose Home > Format > Hide & Unhide > Unhide Columns. If it is at the edge of the sheet, select the whole worksheet first and use Unhide Columns.

Can I hide a column in a protected worksheet?
Only if the worksheet’s protection settings allow that change. If the command is unavailable, ask the workbook owner to allow column formatting or temporarily remove protection if you are authorized to do so.

Can other people see a column I hid?
People with access to the workbook may be able to unhide it and see its contents. Hiding is not a way to secure or permanently conceal information; remove sensitive data or control access to the workbook instead.

Why do the column letters skip after I hide one?
The jump is the visual clue that a column or block is hidden. For example, if the headings go from B to D, column C is hidden. Select the adjacent headings and use Unhide Columns to bring it back.

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.