Excel Hide Columns When Printing Without Changing Data

How-to basics · Updated November 21, 2026

Excel does not have a separate print-only hidden setting for a column: hiding a column on a worksheet also hides it on the printout. To leave the column out of a print job, select its letter, choose Home > Format > Hide & Unhide > Hide Columns, print the sheet, then choose Unhide Columns to restore it onscreen.

What hiding a column changes

In Excel for Microsoft 365 on Windows, a hidden column is hidden in the worksheet view and omitted when that worksheet is printed. It is still part of the workbook: its values and formulas remain, and formulas elsewhere can continue to refer to its cells. Hiding a column is a display change, not a way to delete data or protect it from someone who can open the file.

This matters because Excel applies the hidden state to the sheet itself, not just to the current print job. If you save the workbook while a column is hidden, the next person who opens it will also see that column hidden. Conversely, unhiding it to restore the onscreen view also means it will be included in subsequent prints unless you hide it again or use a different printing method.

There is no ordinary Page Setup checkbox that leaves a column visible on the worksheet but suppresses only that column in print. The best method depends on whether you need a quick one-time print, a repeatable report, or a workbook that other people should see unchanged.

The quick method: hide, print, and unhide

For a one-time print, temporarily hide the column, check the preview, print, and unhide the column afterward. This is simple and preserves the rest of the worksheet, including its formulas and formatting. It is usually the quickest choice when you need to omit a small amount of information from one copy.

  1. Find the column letter at the top of the worksheet. If the column is narrow, use the Name Box to select it: click the Name Box to the left of the formula bar, type a reference such as D:D, and press Enter.
  2. Right-click the selected column letter and choose Hide. Alternatively, use Home > Format > Hide & Unhide > Hide Columns.
  3. Open File > Print and inspect the preview. Confirm that the right column is gone and that the remaining content fits the page as intended.
  4. Print the worksheet. Then select the columns on either side of the hidden one, right-click their column letters, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns.

For example, if column D contains internal notes between customer names in A:C and order totals in E:F, hiding D removes those notes from the printout while leaving the other columns in place. The printed sheet may have less content across its width, but Excel does not necessarily enlarge the remaining columns to fill the gap. Review the preview rather than assuming the page layout will improve automatically.

Keep the worksheet visible while printing

If you want the column visible in the workbook but absent from the printout, avoid changing the original sheet’s hidden state. A reliable approach is to make a separate print sheet containing only the fields intended for readers. Copy the required columns to a new worksheet, arrange them in the desired order, and print that sheet. This takes a little setup, but it gives you a stable report without temporarily changing the view of the source data.

A print sheet is especially useful when the report is printed regularly, shared with colleagues, or needs a different layout from the data-entry sheet. Give the new worksheet a clear name such as Print Report, and label its columns so that it makes sense on its own. If the source data changes, remember to refresh or update the copied report before printing; a normal copy is not automatically linked to future edits.

For a one-off print where you do not want to edit the original workbook, you can also make a copy of the workbook and hide the column in that copy. This reduces the risk of accidentally saving a changed view in the source file. It does not remove the hidden data from the copy, however, so do not treat this as a privacy measure. If recipients must not receive certain information, create a file that does not contain that information.

Using Print Area to control what prints

Print Area can limit printing to a selected range, but it is not a general print-only hide switch. To set one continuous area, select the cells you want included and choose Page Layout > Print Area > Set Print Area. Excel then prints the specified range rather than the entire used portion of the sheet. This can be handy when the unwanted column is outside the range you need.

Be cautious if the column to omit lies between columns you want. Selecting separate ranges on either side and defining multiple print areas does not make Excel join them together into one continuous table with the gap removed. Separate print areas can print as separate areas or pages, which may not be the layout you expect. For a compact report that pulls columns together, a separate print sheet is generally clearer.

To remove a print area later, choose Page Layout > Print Area > Clear Print Area. A print area can also explain why a column remains missing after you unhide it: the column may be outside the defined area. Check both the hidden state and the print area if the preview does not match the worksheet.

Check page layout and print preview

After hiding the column, use File > Print to see the actual print preview before sending the job. The preview reflects choices such as paper size, orientation, margins, scaling, print area, and page breaks. Removing a column can reduce the width enough to change pagination, but it may also leave a large blank space or make the remaining columns appear too small if scaling is set to fit a wider range.

If the result is hard to read, consider these settings rather than hiding additional information at random:

  • Under Page Layout, choose Orientation and try Landscape when the remaining table is still wide.
  • Review Scale to Fit settings. Fit All Columns on One Page can prevent horizontal splitting, but may shrink text substantially.
  • Use Page Layout > Print Titles if column headings need to repeat on each printed page. This is useful for long lists that span multiple pages.
  • Check the page breaks and the paper size selected in the print settings. A preview can show whether a table is split in an inconvenient place.

These layout settings do not make the hidden column visible or invisible by themselves; they control how the remaining printable content is arranged. If confidential or irrelevant information must not appear, confirm that the column is actually hidden or excluded and inspect every preview page before printing.

Keyboard shortcuts and Mac differences

On Windows, Ctrl+0 hides the selected column in many Excel installations. To unhide columns, select the columns around the hidden one and use the ribbon path Home > Format > Hide & Unhide > Unhide Columns. A keyboard shortcut can be convenient, but the ribbon path is easier to verify and avoids confusion when a shortcut is intercepted by Windows settings or a particular keyboard configuration.

On Mac, use the column context menu or the Home tab’s Format menu to hide and unhide columns. Keyboard shortcuts differ from Windows and can depend on macOS keyboard settings, so use the visible menu command if a shortcut does not work. Excel for the web also supports hiding and unhiding columns through the column header context menu; menu placement can vary with the interface, so confirm the hidden state in the sheet and check File > Print or the browser’s print preview before printing.

Common problems and misconceptions

  • The column still appears in the printout. Confirm that you hid the whole column, not just cleared its cells or changed its font color. Then reopen print preview; the preview may have been open before the change.
  • The column is missing when you reopen the file. The hidden state was saved with the workbook. Select the neighboring column headers and use Unhide Columns.
  • Unhide does not seem to work. Select columns on both sides of the hidden one before using Unhide. If several columns are hidden, select a wider range or the whole sheet, then use the command again.
  • Only part of the table prints. Look at Page Layout > Print Area and clear or reset the area if it excludes cells you need.
  • Hiding the column protects its contents. It does not. A recipient can unhide it, inspect formulas, or otherwise access information in the workbook. Remove sensitive data from a file before sharing it if it must not be available.

Another common misconception is that hiding a column deletes it from formulas or changes calculations. Ordinarily it does not: the cells remain in the sheet. Some functions and charts can be configured to treat hidden data differently, so if a report depends on chart settings or a formula that considers visible rows, verify those results separately. For an ordinary table printout, the main effect is that the column is not displayed or printed.

Frequently Asked Questions

Can I hide a column only when printing in Excel?

Not with a built-in print-only visibility setting. Hiding a column also hides it in the worksheet. For a one-time job, hide it, print, and unhide it; for a repeatable report, use a separate print sheet.

Will Excel print a hidden column?

No. A hidden worksheet column is normally omitted from that sheet’s printout. Check the print preview to confirm that the intended column is hidden and that the print area includes the content you still need.

How do I unhide a column after printing?

Select the column headers immediately to the left and right of the hidden column, right-click, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns.

Can I omit a column without changing the original worksheet?

Yes. Make a separate report sheet with only the columns to print, or print from a copy of the workbook. A print area can exclude cells outside a range, but it may not combine columns on either side of an excluded middle column into one continuous table.

Does hiding a column delete its data or make it private?

No. The data remains in the workbook and may still be used by formulas. Anyone with access to the workbook may be able to unhide or inspect it, so hiding is a layout choice rather than data protection.

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.