How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.

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.

When you want to reveal cells that may reside in hidden rows or columns, it can be difficult to locate them. The approach is to first select all visible cells in the worksheet, which also will …

You can filter for unique values to temporarily hide duplicate values, and you can remove duplicate values to permanently delete duplicate values. A duplicate value is one where all …

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

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.

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 …

In Excel for the web, you can remove duplicate values. Important: You can always select Undo to get back your data after you have removed the duplicates. That being said, it's a good idea to …

You can hide any worksheet to remove it from view. The data in hidden worksheets is not visible, but it can still be referenced from other worksheets and workbooks, and you can easily unhide …