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.

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.

These steps work for Microsoft 365 subscribers, as do the steps on the tab below that matches your operating system. For perpetual Office versions, see the tabs below for steps supported …

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 …

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 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 …

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.

How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

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 …

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 …