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.

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."

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.

If you don't want other users to see your formulas, you can hide them from being seen in cells or the Formula bar. For more information, see Display or hide formulas.

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 …

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.

You can show or hide columns in a list or library as an alternative to deleting them. When you hide a column, it doesn't affect the column or the data in the column, as it would if you deleted it.

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 …

If you want to ungroup columns, select the columns, and then go to Data > Outline > Ungroup. If you ungroup an outline while the detail data is hidden, the detail columns can remain hidden.