
Hide or show rows or columns - Microsoft Support
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.
Hide or Unhide worksheets - Microsoft Support
Learn to hide (or unhide) worksheet tabs or workbooks in Excel. Worksheet names appear on the tabs along the bottom of a workbook.
Why do I see a "Cannot shift objects off sheet" message in Excel?
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.
Unhide the first column or row in a worksheet - Microsoft Support
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 Height or Column Width …
Error message when you try to insert or hide rows or columns in …
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."
Hide or display cell values - Microsoft Support
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 …
Lock or unlock specific areas of a protected worksheet
You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.
Locate hidden cells on a worksheet - Microsoft Support
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 …
Show or hide gridlines on a worksheet - Microsoft Support
You can either show or hide gridlines on a worksheet in Excel for the web. On the View tab, in the Show group, select the Gridlines check box to show gridlines, or clear the check box to hide …
Split panes to lock rows or columns in separate worksheet areas
Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.