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...
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. ...
Sub Unhide_Columns_in_Whole_Workbook() Dim x As Worksheet For Each x In Worksheets x.Columns.EntireColumn.Hidden = False Next x End Sub Here is the final image of Using VBA to Unhide Columns. Read More: Unhide Columns Is Not Working in Excel Unhide Columns in Excel Shortcut Not Working...
Unhide Worksheet To show the worksheets once again on the screen, in theRibbon, go toHome > Cells > Format > Hide & Unhide > Unhide Sheet. Alternatively, right-click on the sheet tab to obtain a shortcut menu and clickUnhide. Repeatthe process to display any more sheets that need to b...
When you're ready to view those hidden columns, unhiding them is just as simple as hiding them. Select the columns on each side of the hidden column(s). You can do this easily by dragging through them. Then, right-click and pick "Unhide" in the shortcut menu. ...
On theHometab, in theCellsgroup, clickFormat>Hide & Unhide>Hide Columns. Done! The information that you don't want to view or print is hidden. How to hide columns in Excel with VBA Like many other things, hiding columns in Excel can be automated with VBA. In fact, it's a very sim...
Next, right-click and select the “Hide” option. The sheets are hidden instantly. How to unhide sheets in Excel 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-cl...
Furthermore, if you need to hide rows or unhide columns in Excel, you can also get the relevant methods in this tutorial as well. Hide columns in Excel With the Hide option in context menu With a single click using Kutools With shortcut With the Format option on the ribbon With plus ...
Excel shortcut to hide row If you'd rather not take your hands off the keyboard, you can quickly hide the selected row(s) by pressing this shortcut:Ctrl + 9 How to unhide rows in Excel As with hiding rows, Microsoft Excel provides a few different ways to unhide them. Which one to ...
Hide or unhide a worksheet Note:The screen shots in this article were taken in Excel 2016. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same. Select the worksheets that you want to hide. ...