To keep columns out of a printout in Excel, select the column headers, choose Home > Cells > Format > Hide & Unhide > Hide Columns, then check File > Print before printing. This hides the columns on the worksheet as well as on paper, so unhide them afterward if you want them visible on screen again.
What You’ll Need
- A workbook open in Excel for Microsoft 365 on Windows, with the worksheet you intend to print.
- Permission to change the workbook. If it is shared or important, save a separate copy first so you can restore the original layout.
- A printer is optional. You can use Print Preview to check the result without printing a page.
Step-by-Step
- Open the correct worksheet and identify what should be omitted. Click the sheet tab containing the table, then note the letters at the top of the columns you do not want on paper. Hiding a column affects the whole worksheet, not just the rows currently visible or a selected cell range. Check that you are not removing a field needed to understand the printed figures, such as dates, units, or category labels.
- Select the column or columns by their headers. Click a column letter, such as D, to select the entire column. To select a continuous group, click the first column letter and drag across the last one, or select the first header and Shift-click the last. To select separated columns, hold Ctrl while clicking each header on Windows. On a Mac, use Command-click for separated headers. Selecting the headers makes sure the full columns are hidden, including cells below the part of the table you can see.
- Hide the selected columns. On the ribbon, choose Home > Cells > Format > Hide & Unhide > Hide Columns. You can also right-click one of the selected column letters and choose Hide. The column letters will skip over the hidden columns; for example, after hiding C, the visible headings may go from B to D. The cells are still in the workbook, and formulas that refer to them are not deleted.
- Open Print Preview before sending anything to the printer. Choose File > Print, or press Ctrl+P on Windows. On a Mac, use Command+P to open the print dialog. Look at the preview pages and confirm that the omitted information is gone, the remaining columns are legible, and the right worksheet is selected. Use the page navigation controls if the worksheet spans more than one page; checking only the first page can miss a problem farther along.
- Adjust the print layout if the remaining columns do not fit well. In the Print screen, review the printer, paper size, orientation, margins, and scaling options. If the columns are cut off, choose a landscape orientation or a scaling option such as Fit All Columns on One Page, if available in the scaling menu. Fitting columns to one page can make text quite small, so check every preview page and prefer readable output over forcing a large worksheet onto one sheet of paper.
- Print the worksheet. When the preview looks right, choose the number of copies and pages you need, then click Print. If you only need a digital check, you can stop at the preview or use the available PDF printer or export option instead. Hiding columns does not change the data or erase formulas, but the hidden state is saved with the workbook when you save it.
- Unhide the columns when you want the original on-screen layout back. Return to the worksheet and select the visible column headers on both sides of the hidden section. For example, if C is hidden, select B through D, right-click the selected headers, and choose Unhide. Alternatively, use Home > Cells > Format > Hide & Unhide > Unhide Columns. If the hidden columns are at the far left or right edge, or you cannot tell which ones are hidden, select the whole sheet using the small triangle above row 1 and to the left of column A, then use the Unhide Columns command. This can reveal every hidden column on that sheet, so use it only if that is what you intend.
- Save the layout you want to keep. If you unhid the columns, save the workbook after restoring them. If you deliberately want the workbook to open with those columns hidden, save while they are still hidden instead. In a shared workbook, let collaborators know if the hidden state is temporary; hiding columns changes what they see in the worksheet, even though it does not remove the information.
Common Mistakes
- Hiding cells rather than whole columns. Selecting a few cells and changing their appearance does not hide the columns from the printout. Click the lettered column headers before choosing Hide Columns.
- Assuming hidden means deleted or private. The data remains in the file and can be revealed by unhiding the column. Do not use hiding as a way to protect confidential information. Use appropriate file permissions or remove sensitive data from a copy before sharing or printing.
- Forgetting that the worksheet view changes too. A column hidden to improve a printout is also hidden for anyone viewing that worksheet in the workbook. Restore it after printing if the normal on-screen layout should remain visible.
- Printing without checking every page. A column may be hidden correctly while the remaining content is still split awkwardly, too small, or missing from a later page. Inspect the full preview, not just the first page.
- Hiding a column that provides necessary context. Removing a unit, heading, or identifier can make the printed numbers confusing. Keep the information needed to interpret the report, even if that means adjusting the page layout instead of hiding another column.
Tips
Use a temporary copy if you only need a one-off print layout and are unsure which columns other people expect to see. Give the copy a clear name, hide the unnecessary columns in it, and leave the original unchanged. This is especially useful when the workbook is a template or is used by several people.
For adjacent columns, selecting the first and last headers is quicker than clicking every one. For columns that are not next to each other, Ctrl-click the headers on Windows or Command-click them on Mac before using Hide Columns. If you accidentally hide the wrong column, press Ctrl+Z on Windows or Command+Z on Mac to undo the hide action immediately; if you have made other changes since then, use the Unhide command instead.
Hidden columns are not the same as removing a field from the print range. If your goal is to print only a particular contiguous block of a worksheet while keeping all columns visible on screen, select that block and use Page Layout > Print Area > Set Print Area. Then inspect File > Print, because print areas and page breaks can affect how the output is divided. For a simple report that should omit a few whole columns, hiding them is usually more direct.
Before printing a wide table, consider whether landscape orientation or narrower margins will preserve more useful information than hiding additional fields. If you use scaling to fit columns on one page, check that the resulting type remains readable at normal print size. A preview on screen is a useful check, but a single test page can reveal issues such as faint text or clipped edges that are hard to judge from the monitor.
Troubleshooting
- The Hide Columns command is unavailable or nothing happens: Confirm that you selected one or more column headers, rather than only cells. If the worksheet is protected, changes to its structure may be restricted; ask the workbook owner to unprotect it or provide an editable copy.
- The column letters jump, but the column still seems visible: Look closely at the boundary between the neighboring headers. A very narrow column may have been resized instead of hidden. Select its header and use Home > Cells > Format > Column Width to give it a visible width, then repeat Hide Columns.
- The print preview still shows information you expected to disappear: Return to the worksheet and check that the relevant columns are actually hidden on the sheet you are printing. In File > Print, verify the selected printer and the print setting, such as Print Active Sheets or Print Selection. Also check whether you are previewing a different worksheet or workbook than the one you edited.
- Some remaining columns are missing from the page: The worksheet may have a defined print area or scaling that limits what is printed. Review Page Layout > Print Area and the scaling options in the Print screen. Clear or reset an unwanted print area if necessary, then check the preview again.
- You cannot unhide a column at the left edge: Click the triangle at the top-left corner of the sheet to select all cells, then choose Home > Cells > Format > Hide & Unhide > Unhide Columns. Be aware that this reveals all hidden columns on that worksheet, not only the one at the edge.
Frequently Asked Questions
Do hidden columns print in Excel?
Normally, no. When a whole worksheet column is hidden, its contents are excluded from the printed worksheet. Confirm the result in File > Print, particularly if the workbook has a print area or unusual page setup.
Can I hide columns only for printing but leave them visible on screen?
Not with the standard Hide Columns command: it changes the worksheet view as well as the printout. For a one-time print, hide the columns, print, and unhide them. For a separate layout, use a copy of the sheet or workbook, or set a print area that includes only the required cells.
Will hiding a column change formulas that use it?
No. Hiding a column does not delete its data, and formulas that refer to its cells continue to use those cells. The column can still be unhidden later. Remember that a printed report may omit information that a formula result depends on, so include enough context for readers.
How do I hide several columns that are not next to each other?
On Windows, hold Ctrl and click each column letter you want to hide. On Mac, use Command-click. With the headers selected, choose Home > Cells > Format > Hide & Unhide > Hide Columns, then review the preview.
Can I undo hiding a column?
Yes. Press Ctrl+Z on Windows or Command+Z on Mac immediately after hiding it. You can also select the neighboring column headers and choose Unhide from the right-click menu or the Home tab’s Format menu.
Does this work in Excel for the web?
Excel for the web also lets you hide selected columns from the column-header context menu and print from the browser-based workbook. Ribbon options can differ from desktop Excel, so use the web version’s column menu and check its print preview before printing.
Related
- Count Cells by Color in Excel: Methods and Their Limits
- Excel Columns: How Many Are There in a Full Worksheet?
- AGGREGATE Excel: How to Sum While Ignoring Errors
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Automatic Text to Columns in Excel: Options and LimitsExcel does not have a built-in setting that automatically runs Text to Columns whenever you type or paste…
- Flash Fill in Excel: How It Works and When to Use ItFlash Fill in Excel automatically completes a column when it recognizes a pattern in examples you provide. In…
- Excel Consolidate Cells: Merge or Combine Data?In Excel, “consolidate cells” can mean merging cells into one larger cell, joining the contents of several cells,…
- MS Word Data Table: How to Create, Format, and Use ItIn Microsoft Word for Microsoft 365, make a data table by choosing Insert > Table, then selecting the…
- Insert a Row in a QuickBooks Journal Entry CorrectlyTo insert a row in a QuickBooks journal entry, open the entry and add a line: in QuickBooks…
- Google Sheets: Count Checked and Unchecked CheckboxesTo count checked checkboxes in Google Sheets, use =COUNTIF(A2:A20,TRUE), assuming the checkboxes are in A2:A20 and use the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.