
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.
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.
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.
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.
Show the Developer tab - Microsoft Support
Under Customize the Ribbon and under Main Tabs, select the Developer check box. After you show the tab, the Developer tab stays visible, unless you clear the check box or have to …
Unhide the first column or row in a worksheet - Microsoft Support
You can select the entire worksheet, and then unhide rows or columns (Home tab, Cells group, Format button, Hide & Unhide command), but that displays all hidden rows and columns in …
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.
Lock or unlock specific areas of a protected worksheet
In the Format Cells dialog box, select the Protection tab and uncheck the Locked box and then select OK. This unlocks all the cells on the worksheet when you protect the worksheet.