Excel shortcuts

25 Excel Shortcuts for Hiding Columns (and Rows)

If you're working with a large spreadsheet in Microsoft Excel, you may want to hide some columns or rows to make it easier to read. Hiding columns and rows is a great way to declutter your worksheet and make it more presentable. Luckily, there are a few different ways to quickly hide columns and rows in Excel.

To hide columns, you can:

  • Select the columns you want to hide and right-click. From the menu that appears, select "Hide."
  • Select the columns you want to hide and go to the "Home" tab. In the "Cells" group, click "Format." From the drop-down menu, select "Hide & Unhide" and then "Hide Columns."
  • Select the columns you want to hide and press "Ctrl+-" (minus sign).

To hide rows, you can:

  • Select the rows you want to hide and right-click. From the menu that appears, select "Hide."
  • Select the rows you want to hide and go to the "Home" tab. In the "Cells" group, click "Format." From the drop-down menu, select "Hide & Unhide" and then "Hide Rows."
  • Select the rows you want to hide and press "Ctrl+Shift+-" (minus sign).

To unhide columns or rows, you can:

  • Select the columns or rows next to the hidden columns or rows. Right-click and select "Unhide" from the menu that appears.
  • Select the columns or rows next to the hidden columns or rows. Go to the "Home" tab. In the "Cells" group, click "Format." From the drop-down menu, select "Hide & Unhide" and then "Unhide Columns" or "Unhide Rows."
  • Select the columns or rows next to the hidden columns or rows and press "Ctrl+Shift+*" (asterisk).

You can also hide columns and rows by using the "Hide" and "Unhide" options in the "Format" drop-down menu. To do this:

  • Go to the "Home" tab. In the "Cells" group, click "Format."
  • From the "Format" drop-down menu, select "Hide & Unhide."
  • From the submenu that appears, select "Hide Columns" or "Hide Rows."

To unhide columns or rows using the "Format" drop-down menu:

  • Go to the "Home" tab. In the "Cells" group, click "Format."
  • From the "Format" drop-down menu, select "Hide & Unhide."
  • From the submenu that appears, select "Unhide Columns" or "Unhide Rows."

Hiding columns and rows is a great way to make your Excel spreadsheets more presentable and easier to read. With these 25 shortcuts, you can quickly hide and unhide columns and rows in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.