Hide Columns In Excel Update If The

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

Michael Heine is a CompTIA-certified writer, editor, and Network Engineer with 25 years experience working in the television, defense, ISP, telecommunications, and education industries.

You can hide columns and rows in Excel to make a cleaner spreadsheet without deleting data you might need later.

As in all Microsoft programs, there is more than one way of accomplishing a task.

The directions below cover three ways to hide and unhide columns and rows in an Excel worksheet.

When you hide columns and rows containing data, that doesnt delete the data, and you can still reference it in formulas and charts.

Hide Columns In Excel Update If The

Hidden formulas containing cell references will update if the data in the referenced cells changes.

The column containing the active cell should be hidden from view.

The options available in the context or right-click menu change depending upon the object selected when you open the menu.

If the Hide option, as shown in the image below, is not available in the context menu it is likely that you didnt select the entire column before right-clicking.

Choose Hide. The selected column, the column letter, and any data in the column will be hidden from view.

Choose Hide. The selected columns and column letters will be hidden from view.

Continue to hold down the Ctrl key and click once on each additional column to be hidden to select them.

In the column header, right-click on one of the selected columns.

Press the Enter key on the keyboard to select the hidden column.

Click on the Format icon on the ribbon to open the drop-down.

In the Visibility section of the menu, choose Hide Unhide Hide Columns or Unhide Column.

Press and hold down the Ctrl and the Shift keys on the keyboard.

Press and release the 0 key without releasing the Ctrl and Shift keys.

To unhide one or more columns, highlight at least one cell in the columns on either side of the hidden column(s) with the mouse pointer.

Hide Columns In Excel For Mac