How to Hide Columns in Excel

PDF download Download Article
A complete guide to shielding Excel columns so they aren’t visible to others
PDF download Download Article

Want to hide certain columns in your spreadsheet? Hiding columns in Excel is a great way to get a better look at your data, especially when printing. We'll show you how to hide columns in a Microsoft Excel spreadsheet, as well as how to show columns that you've hidden.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d6\/Hide-Columns-in-Excel-Step-1-Version-2.jpg\/v4-460px-Hide-Columns-in-Excel-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d6\/Hide-Columns-in-Excel-Step-1-Version-2.jpg\/aid9088762-v4-728px-Hide-Columns-in-Excel-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    • If Excel is already open, you can open your spreadsheet by pressing Ctrl + O (Windows) or Cmd + O (macOS) and then selecting the file.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Hide-Columns-in-Excel-Step-2-Version-2.jpg\/v4-460px-Hide-Columns-in-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/3b\/Hide-Columns-in-Excel-Step-2-Version-2.jpg\/aid9088762-v4-728px-Hide-Columns-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This selects the entire column.
    • For example, to select the first column (column A), click the A at the top of the column.
    • If you want to hide multiple columns at once, just click and drag your cursor over the column letters you want to hide.
    • You can also select multiple non-adjacent columns by holding down Ctrl as you click each column letter.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/90\/Hide-Columns-in-Excel-Step-3-Version-2.jpg\/v4-460px-Hide-Columns-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/90\/Hide-Columns-in-Excel-Step-3-Version-2.jpg\/aid9088762-v4-728px-Hide-Columns-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This brings up a menu.
    • If you don't have multiple mouse buttons, hold down the Ctrl key as you click the column(s) instead.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e6\/Hide-Columns-in-Excel-Step-4-Version-2.jpg\/v4-460px-Hide-Columns-in-Excel-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/e6\/Hide-Columns-in-Excel-Step-4-Version-2.jpg\/aid9088762-v4-728px-Hide-Columns-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Any selected columns are now hidden. [1]
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Hide-Columns-in-Excel-Step-5.jpg\/v4-460px-Hide-Columns-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/b\/bd\/Hide-Columns-in-Excel-Step-5.jpg\/aid9088762-v4-728px-Hide-Columns-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you want to show columns that are hidden, just click any column adjacent to those hidden to select it, and then choose Unhide .
    6. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Password Protect a Microsoft Excel Spreadsheet
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8

      About This Article

      Article Summary X

      1. Open your spreadsheet.
      2. Select the column(s) you want to hide.
      3. Right-click the selected column(s).
      4. Click Hide .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 54,066 times.

      Is this article up to date?

      Advertisement