Hide or unhide a workbook window On the View tab, in the Window group, click Hide or Unhide. On a Mac, this is under the Window menu in the file menu above the ribbon.
To be able to see a very hidden worksheet again, you just need to change its Visible property back to xlSheetVisible. Press Alt + F11 to open the Visual Basic Editor. In the VBAProject window, select the worksheet you want to unhide. In the Properties window, set the Visible property to -1 - xlSheetVisible.
On the Home tab in the Cells group, click Format > Hide and Unhide and choose either Unhide Rows or Unhide Columns.
When there's a lot of sheets in a document, not all of the tabs can be displayed at once. In the following example, there are 20 worksheets, but only 7 of them are visible. To see the whole list of worksheets, right-click the arrow to the left of the sheet tabs.
The file might be locked because: The file is shared and another user is currently editing it. An instance of the Office app is running in the background with the file already opened. The file has been marked as Final and can no longer be updated.
Step 1− Select the cell in the worksheet from which you need to remove the data value restriction. Step 2− Click Data Validation under Data > Data Tools. Step 3− Click Clear All under the Settings Tab of the dialog box as shown below. If you want to remove the similar data restriction from all other cells.
By default, when you protect cells in a sheet or workbook, all of the cells will be locked. This means they can't be reformatted or deleted, and the content in them can't be edited. By default, the locked cells can be selected, but you can change that in the protection options.
When there's a lot of sheets in a document, not all of the tabs can be displayed at once. In the following example, there are 20 worksheets, but only 7 of them are visible. To see the whole list of worksheets, right-click the arrow to the left of the sheet tabs.
You can also use the Ctrl+Tab shortcut to cycle through all the sheets in your workbook. And if you want to move directly to a specific sheet, you can press Ctrl+PgUp or Ctrl+PgDn and then use the arrow keys to select the sheet you want.
If you're working with a spreadsheet that contains sensitive or private data, then some rows and columns might be hidden. You might also need to hide unimportant information or data you don't want others to see in your own spreadsheet.
If you're trying to unhide rows at the top of the worksheet, click on the first visible row, and then move your mouse up to the top of the screen. Alternatively, you can select a row or rows, and then press Ctrl-9. To unhide rows, press Ctrl-Shift-9.
First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.
Click the Select All button. Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
If you click HIDE, the workbook will disappear but it is still operational and open. In order to see it again, click the UNHIDE option in the VIEW tab and it will give you a list of hidden workbooks.
If you have a PC, to reopen a browser, hold the "shift+control+T" keys. This will restore the most recently closed tabs, whether it's just one or multiple. However, if you had multiple windows of several tabs open, you will need to do the key function for however many windows you had open.