Right-click and choose Unhide from the Context Menu. Alternatively, drag the cursor icon to the right to reveal the hidden column. Read More: How to Hide Columns with Button in Excel Method 2 – Hide and Unhide Columns with Format Tool Select the column you want to hide (e.g., Column...
Right-click on the Sheet tab at the bottom and select the “Unhide” option. In the Unhide dialog box, press the Ctrl key and click the sheets you want to show, or press the Shift + Up/Down Arrow keys to select multiple (or all) worksheets, and then press OK. How do I automatical...
As with hiding rows, Microsoft Excel provides a few different ways to unhide them. Which one to use is a matter of your personal preference. What makes the difference is the area you select to instruct Excel to unhideall hidden rows, onlyspecific rows, or thefirst rowin a sheet. Unhide ...
Follow the steps below to unhide sheets in Excel: Step 1:Open the Excel file. If it is not already opened, open the Excel file with hidden sheets. You can either double-click on the file or open it directly from the Excel application. To open a file in Excel, open the application, ...
.Find(What:="X", LookIn:=xlFormulas)IfNotm_rnFindIsNothingThenm_stAddress = m_rnFind.Address'Unhide the column, and then find the next X.Dom_rnFind.EntireColumn.Hidden =FalseSetm_rnFind = .FindNext(m_rnFind)LoopWhileNotm_rnFindIsNothingAndm_rnFind.Address <> m_stAddressEndIfEndWith...
ClickOKto unhide the selected worksheet and to close the dialog box. Unhide Worksheets Using the Ribbon As with hiding worksheets, Excel has no keyboard shortcut for unhiding a sheet, but you can still use the ribbon. Select one or moreworksheet tabsat the bottom of the Excel file. ...
1. Click on a cell in the Row you want to hide. (Use CTRL and/or SHIFT to select multiple cells). 2. PC Shortcut:Ctrl+9 Mac Shortcut:^+9 Unhide Rows To unhide row(s): 1. Highlight the two rows before and after the hidden row. ...
Demo: Easily hide or unhide multiple named ranges in Excel Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features!Download Now! Productivity Tools Recommended The following tools can greatly save your time and money, which one is right for you?
On which Excel version you are and how you do that? For example, I'm here Select columns B and CO with pressed Ctrl. Right click, Unhide. And I'm still at the same place This will keep the selected rows and columns frozen, allowing you to scroll through the spreadsheet while retaining...
Hide and Unhide Rows in Excel To hide one or more consecutive rows, first select the rows. Then, do one of the following: Right-click on the selected rows and selectHide. PressCtrl + 9. ✕Remove Ads The selected rows are replaced with a double line in the row headings and a thick...