Hide or Unhide worksheets - Microsoft Support
Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets. To hide the sheet, select Hide. To unhide hidden sheets, select them in the Unhide dialog that appears, and then select OK. Press and hold CTRL, then click the items to select them.
Locate hidden cells on a worksheet - Microsoft Support
Follow these steps: Press F5 > Special. Press Ctrl+G > Special. Or on the Home tab, in the Editing group, click Find & Select>Go To Special. Under Select, click Visible cells only, and then click OK. All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns will appear with a white border.
Hide or display cell values - Microsoft Support
By applying a custom number format, you can hide the values of certain cells on the worksheet.
Copy visible cells only - Microsoft Support
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.
Unhide the first column or row in a worksheet - Microsoft Support
To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing …
Hide or show rows or columns - Microsoft Support
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.
Hide error values and error indicators in cells - Microsoft Support
You can hide error values by converting them to a number such as 0, and then applying a conditional format that hides the value. Create an example error. Open a blank workbook, or create a new worksheet. Enter 3 in cell B1, enter 0 in cell C1, and in cell A1, enter the formula =B1/C1. The #DIV/0! error appears in cell A1.
Remove hidden data and personal information by inspecting …
Document Inspector helps you find and remove hidden data and personal information stored in documents that you plan to share. Here's how to use it. Tip: If you're just looking to print without comments, on the File tab select Print, choose Print All Pages, and clear Print Markup.
Display or hide formulas - Microsoft Support
On the Protection tab, clear the Hidden check box. Make cells display the formulas they contain, instead of the formula results. Protect cells so that formulas cannot be displayed or changed.
Use the Selection pane to manage objects in documents
You can use the Selection pane to manage objects in your document: re-order them, show or hide them, and group or ungroup them. Tip: In Word, you might want to set the location of objects within a paragraph. When you move a paragraph, the corresponding anchored image (s) move with the paragraph.
Where are my worksheet tabs? - Microsoft Support
To unhide a worksheet, right-click on any visible tab and then click Unhide. In the Unhide dialog box, click the sheet you want to unhide and then click OK. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Learn how to show the worksheet tabs at the bottom of your Excel workbook.