Search results
Results from the WOW.Com Content Network
The data in hidden worksheets is not visible, but it can still be referenced from other worksheets and workbooks, and you can easily unhide hidden worksheets as needed. Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets.
Viewing scenarios that you have hidden, making changes to scenarios that you have prevented changes to, and deleting these scenarios. Users can change the values in the changing cells, if the cells are not protected, and add new scenarios.
The macro displays a message box that lists three items: (1) whether the defined name is visible or hidden, (2) the defined name, and (3) what that name refers to (the workbook cell reference). You may choose Yes or No to delete or to keep each defined name.
Display hidden cell values. Select the cell or range of cells that contains values that are hidden. For more information, see Select cells, ranges, rows, or columns on a worksheet .
If you don’t see the first column (column A) or row (row 1) in your worksheet, it might be hidden. Here’s how to unhide it. In this picture column A and row 1 are hidden.
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 reveal hidden rows and columns.
If you don't want the formulas hidden when the sheet is protected in the future, right-click the cells, and select Format Cells. On the Protection tab, clear the Hidden check box.
If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only.
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.
If the gridlines on your worksheet are hidden, you can follow these steps to show them again. Select one or more worksheets.
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.