
Hide or Unhide worksheets - Microsoft Support
On the Home tab, in the Cells group, click Format > Visibility > Hide & Unhide > Hide Sheet. To unhide worksheets, follow the same steps, but select Unhide. You'll be presented with a dialog …
Where are my worksheet tabs? - Microsoft Support
If you can't see the worksheet tabs at the bottom of your Excel workbook, browse the table below to find the potential cause and solution. Note: The images in this article are from Excel 2016. …
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 the ribbon in Office - Microsoft Support
To see the ribbon again, just double-click any ribbon tab, or press CTRL+F1. If the ribbon isn't visible at all (no tabs are showing), then you probably have it set to Auto-hide.
Show the ribbon - Microsoft Support
Expand the ribbon in Excel to find the commands you need. Click any tab to show the Ribbon, or use the Ribbon Display Options at the top of your document.
Manage workbook links - Microsoft Support
There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.
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.
Manage queries (Power Query) - Microsoft Support
You can manage your queries either in the Queries pane of the Power Query Editor or on the Queries tab of the Queries & Connections pane in Excel. This is especially helpful if you have …
Display or hide formulas - Microsoft Support
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.
Find cells that contain formulas - Microsoft Support
To find cells that contain formulas, click Home, Find & Select, and Go To. Click Special, and then click Formulas. You can search part or all of a worksheet.