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.

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 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 information, you …

When working with a data model in Power Pivot, you can hide columns that you don't want to appear in a Power View and other reporting applications.

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 …

On the Home tab, in the Cells group, click Format > Visibility > Hide & Unhide > Hide Sheet. To unhide worksheets, follow the same steps, but select Unhide. You'll be presented with a dialog box listing …

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 …

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