How to Hide the Rest of the Columns in Excel

How-to basics · Updated November 18, 2026

To hide every column to the right of your data in Excel for Microsoft 365 on Windows, select the first column you want hidden, select through column XFD, then choose Home > Format > Hide & Unhide > Hide Columns. The columns are still in the worksheet; hiding them simply keeps them out of view until you unhide them. Before you start, decide which column should be the last one visible so you do not conceal information you still need.

What You’ll Need

  • An Excel workbook with the worksheet you want to tidy up.
  • The letter of the last column you want to keep visible. For example, if your table ends in column E, the first column to hide is F.
  • Permission to make changes to the sheet. If the worksheet is protected, you may need its password or help from the workbook owner.

Step-by-Step

  1. Open the correct worksheet. Select the worksheet tab at the bottom of the Excel window. If the workbook has several tabs, confirm that you are on the sheet you intend to change. Hiding columns affects only the active worksheet unless you select multiple sheet tabs first; for a first attempt, keep just one sheet selected.
  2. Choose the first column to hide. Find the last column you want to leave visible. If you want the sheet to show columns A through E, the first column to hide is F. You hide whole columns, not just the blank cells in them, so any data farther down in column F will also become hidden.
  3. Select the columns from that point to the end of the worksheet. Click the Name Box, which is the small box to the left of the formula bar and usually displays the active cell address, such as A1. Type a column range such as F:XFD, replacing F with your first column to hide, and press Enter. Excel selects every column in the range. XFD is the last column in a modern Excel worksheet. If you cannot see the Name Box, turn it on from View > Show > Formula Bar, or use the selection method in the next paragraph.
  4. Alternatively, select with the column headers. Click the letter at the top of the first column you want hidden. In Windows, hold Ctrl+Shift and press the Right Arrow key to extend the selection to the last column. Check the highlighted column headers before proceeding. If the selection stops early because of the worksheet’s layout or your selection began inside cells rather than on a header, use the Name Box method instead. On a Mac, use the Name Box range method to avoid differences in keyboard shortcuts and keyboard settings.
  5. Hide the selected columns. On Windows, go to Home > Format > Hide & Unhide > Hide Columns. The selected column headings disappear, and the remaining visible columns sit next to one another. You can also right-click one of the selected column headings and choose Hide. On a Mac, select the columns and use Format > Column > Hide from the menu bar; the Home tab’s Format menu may also offer Hide Columns depending on the ribbon layout.
  6. Check the new edge of the sheet. Look at the column letters after hiding. If column E is the last one you kept, the visible headings should go from E to the next visible area or edge of the worksheet, with the hidden range omitted. Click a few cells in the visible area to confirm the sheet is still usable and that the intended information remains visible.
  7. Save the workbook if you want to keep the change. Press Ctrl+S on Windows or Command+S on Mac. Hiding columns is a view and layout change, but it is saved with the workbook. It does not delete cell contents, formulas, formatting, or comments in those columns.
  8. Unhide columns when needed. To restore the hidden range, select the visible column headers on both sides of it, right-click the selection, and choose Unhide. If you hid everything from F to XFD, select column E and the next visible column to its right if one is available, then choose Unhide. Another reliable option is to select the full worksheet using the triangle at the intersection of the row and column headings, then choose Home > Format > Hide & Unhide > Unhide Columns. This restores all hidden columns on that sheet, not only the range you just hid.

The Name Box method is usually the clearest way to hide the remainder of a sheet because it names the exact range you intend to select. For instance, entering G:XFD selects columns G through the final worksheet column, leaving A through F visible. This is useful when the columns you want hidden are far beyond the portion of the sheet you normally use.

Common Mistakes

  • Starting one column too early or too late. If your data ends in E, hiding E:XFD also hides the data in E. Start with F to keep E visible. Before hiding, compare the first selected heading with the last column you want displayed.
  • Selecting cells instead of whole columns. Selecting a block such as F1:XFD20 does not clearly express that you want to hide every column. Select column headings or enter a column-only range like F:XFD in the Name Box.
  • Assuming hidden means deleted. The values and formulas remain in the workbook. They may still affect calculations, and a person with access to the sheet can unhide them. Hiding columns is not a way to protect confidential information.
  • Expecting the worksheet to end at your data. Hiding the unused columns changes what is displayed, but Excel still has its normal worksheet grid and column limit. It does not permanently remove columns or prevent someone from adding content elsewhere.
  • Hiding columns on several selected sheets by accident. When multiple worksheet tabs are grouped, many changes apply to all of them. Check that only the intended sheet tab is selected before hiding columns. If tabs look grouped or highlighted together, right-click a tab and choose Ungroup Sheets.

Tips

  • Keep a small working area visible. Hide only columns that are genuinely outside the useful layout. Leaving a spare visible column can make it easier to add a note or a new field later without immediately unhiding a large range.
  • Use Freeze Panes for a different problem. If you need to keep important columns visible while scrolling sideways, hiding the rest may not be the right choice. Freeze Panes can keep selected columns on screen while you move through other columns; hiding them removes them from view altogether.
  • Consider the audience. A saved workbook opens with the columns hidden for other people, too. If recipients need to see the full dataset, tell them that columns are hidden or leave a short note in a visible cell or worksheet.
  • Make the change easy to reverse. Remember which column began the hidden range, or note it in a comment or documentation area. If the range is extensive, selecting the whole sheet and choosing Unhide Columns restores all hidden columns on that worksheet.
  • Set up printing separately. Hidden columns are generally omitted from a worksheet printout, but check Print Preview before sharing a printed copy. For more precise control over what prints, set a print area rather than relying only on hidden columns.

Troubleshooting

The columns did not disappear. Confirm that you selected the column headings or entered a range such as F:XFD in the Name Box, then run Hide Columns again. If only cells were selected, Excel may not have selected the entire columns. You can also right-click a selected column letter and choose Hide.

The wrong columns disappeared. Press Ctrl+Z on Windows or Command+Z on Mac immediately to undo the last change, then repeat the selection using the correct starting letter. If you already made other changes, do not undo blindly; instead, select the range you want visible and use Unhide. Excel may not offer a convenient undo after closing and reopening the workbook.

You cannot select or unhide the columns. The worksheet may be protected. Check Review > Protect Sheet; if protection is active, ask the owner for permission or the password before changing it. A workbook’s structure protection can also limit changes to sheets. Do not try to bypass protections on a workbook you do not own.

The first visible column is not the one you expected. Check for other hidden columns in the middle of the worksheet. For example, if C and D were already hidden, hiding E:XFD will make B appear to jump directly to the next visible heading. Unhide the relevant range or use the select-all triangle and Unhide Columns to restore the sheet before starting again.

The worksheet still scrolls farther than expected. Excel’s scrollable grid does not shrink when columns are hidden. If your goal is to restrict where users can navigate or enter data, hiding columns alone does not do that. You may need a different workbook design or appropriate sheet protection; protection settings should be chosen carefully so users can still do the tasks they need.

Frequently Asked Questions

Can I hide every column after a certain letter?
Yes. If E should be the last visible column, select F:XFD in the Name Box and choose Hide Columns. Substitute the first column you want hidden for F.

Does hiding columns delete or change their contents?
No. Hiding changes their visibility, not their cell contents. Formulas can continue to use values in hidden columns, and those values can be seen again by unhiding the columns.

How do I hide the remaining columns in Excel for the web?
Select the first column heading to hide, extend the selection through the remaining columns using the column headings or the Name Box if available, then use the column heading context menu and choose Hide. The ribbon and selection controls can vary slightly by browser and Excel for the web updates.

Can I hide columns without using the mouse?
On Windows, select the first unwanted column and use Ctrl+Shift+Right Arrow to extend the selection, then use the ribbon command Home > Format > Hide & Unhide > Hide Columns. On Mac, keyboard behavior can differ, so selecting a range through the Name Box and choosing the Hide command is a dependable alternative.

How do I show the columns again?
Select the visible headings on either side of the hidden range and choose Unhide from the right-click menu. If the hidden range reaches the end of the sheet, select the whole worksheet and use Home > Format > Hide & Unhide > Unhide Columns.

Will hiding columns keep other people from seeing the data?
No. Anyone with access to the worksheet can usually unhide the columns. Use appropriate access controls or remove sensitive data from a shared copy instead of relying on hidden columns for privacy.

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.