Hide columns Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide.

To unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows.

Sometimes, the following message prevents you from inserting or hiding columns or rows in a worksheet. If you see this message, refer to the following table for possible solutions.

Explains that you receive a "Cannot shift objects off sheet" error message when you hide columns in Excel. You can change the position property of the object to "Move and size with cells."

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

By applying a custom number format, you can hide the values of those cells on the worksheet. Note: Although cells with hidden values appear blank on the worksheet, their values remain displayed in …

While using a Sheet View, you can hide or display columns and rows just as you would normally. This lets you see only the columns and rows you care about without changing the view for others.

In the Table Style Options group, select the Header Row check box to hide or display the table headers. If you rename the header rows and then turn off the header row, the original values you input will be …

Show or hide subtotals and grand totals in a PivotTable to add or remove them, and calculate them with or without filtered items.

When using a data model for a Power View or PivotTable report, you can hide entire tables or individual columns so that only relevant items appear in the field list. This is particularly useful when you have …