Frozen Panes and unhiding rows Go to the VIEW and FREEZE PANES buttons. If it says 'Unfreeze Panes' then this is the problem. Once you unfreeze them you will be able to scroll upwards and see the hidden rows.
Right-click the selected columns, and then select Unhide.
The workbook is protected
It is not possible to hide or unhide sheets if the workbook structure has been protected (should not be confused with workbook-level password encryption or worksheet protection). To check this, go to the Review tab > Changes group and have a look at the Protect Workbook button.
The shortcut for hiding columns in Excel is Ctrl + 0. For the sake of clarity, the last key is zero, not the uppercase letter "O". To hide a single column, select any cell within it, then use the shortcut. To hide multiple columns, select one or more cells in each column, and then press the key combination.
On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.
Only users with the Owner or Manager permission type can hide columns. If the hide columns feature is greyed out, your cursor shows a not allowed symbol when you hover over the hide columns button, or you are not able to hide or unhide columns, then you do not have sufficient permissions to hide or unhide columns.
What Does “Grey Out” Mean In MS Excel? In Excel, grey out refers to the process of making a cell uneducable. This can be useful if you want to prevent users from accidentally changing a cell's value, or if you want to make sure that a certain value is entered into a cell before other calculations can be performed.
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.
Click on the right side of your mouse within the selected range. A menu will pop up and show unhide rows option. Choose "Unhide rows." Or, you can use the critical shortcut Ctrl+Shift+9.
Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.
Press the shortcut “Ctrl+Shift+9” to unhide all rows. Press all keys together. Select the entire worksheet again. Press the shortcut “Alt H O U L” to unhide all columns.
You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.
Click the Format button under the Home tab. Select Hide & Unhide. Select Unhide Rows or Unhide Columns. Right-click the selected row(s) or column(s) and select Unhide from the contextual menu.
Using the Excel Options dialog box. Open the File menu and select Options from the left navigation pane to open the Excel Options dialog box. The dialog box has categories for General, Formulas, Data, Proofing, Save, Language, Ease Of Access, Advanced, Customize Ribbon, Quick Access Toolbar, Add-Ins, and Trust Center.
On the Home tab, click Find & Select > Go To (in the Editing group). Keyboard shortcut: Press CTRL+G. Click Special. In the Go To Special dialog box, click one of the following options.
Ctrl+G in Excel and other spreadsheet programs
In Microsoft Excel and most other spreadsheet programs, pressing Ctrl + G opens the Go To window that lets you focus a specific reference (cell). For example, you could press Ctrl + G , type n8, and press Enter to move to the N8 cell.
Office button --> excel options --> Advance --> under the display tick show control characters.
F5 Displays the Go To dialog box. Ctrl+F5 restores the window size of the selected workbook window. F6 Switches between the worksheet, ribbon, task pane, and Zoom controls.