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.

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.

Do one of the following: Under Visibility, select Hide & Unhide, and then select Unhide Rows or Unhide Columns. Under Cell Size, select Row Height or Column Width, and then in the Row …

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 …

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 …

If you want to display or print only certain columns for your datasheet, you can hide the columns that you don't want displayed. For example, if you are working with a database of contact …

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.

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