Unhide Rows In Excel Professional Presentations And

This control over what can be seen or not can be helpful in hiding content such as.

Or right-click the column header and choose the Hide option.

You can also select surrounding rows or columns, right-click the row or column header, and choose the Unhide option in the resultant menu.

Unhide Rows In Excel Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

An Excel worksheet is a single spreadsheet that contains cells.

Each cell can hold text, a number, or a formula, and each cell can reference a different cell on the same worksheet, the same workbook, or a different workbook.

By default, all open Excel workbooks display worksheet tabs on the taskbar at the bottom of the screen, but you can hide or display them as needed.

The options available in the contextual menu the right-click menu change depending on what is selected.

If the Hide option is inactive or grayed out, most likely the current workbook has only one worksheet.

Excel deactivates the Hide option for single-sheet workbooks because there must always be at least one visible sheet.

In the menu, click the Hide option to hide the selected worksheet.

Right-click on one worksheet tab to open the contextual menu.

In the menu, click on the Hide option to hide all the selected worksheets.

Excel has no keyboard shortcut for hiding worksheets, but you can use the ribbon bar to accomplish the same task.

Select one or more worksheet tabs at the bottom of an Excel file.

You can unhide tabs using the contextual menu, just as you can hide them.

Right-click a worksheet tab to open the Unhide dialog box, which displays all the currently hidden sheets.

Click OK to unhide the selected worksheet and to close the dialog box.

As with hiding worksheets, Excel has no keyboard shortcut for unhiding a sheet, but you can still use the ribbon.

Select one or more worksheet tabs at the bottom of the Excel file.

How To Unhide Rows In Excel For Mac