How to hide row, column, window and sheet in Excel (unhide all sheets with VBA)
We can hide both rows and columns and workbook windows in Excel, as well as a sheet and only tables.
Chapters:
0:00 How to hide row in Excel?
0:15 How to unhide row in Excel?
0:41 How to hide multiple rows in Excel?
1:04 How to unhide multiple rows in Excel?
1:17 How to hide column in Excel?
1:27 How to unhide column in Excel?
1:47 How to hide multiple columns in Excel?
1:58 How to unhide multiple columns in Excel?
2:08 How to hide window in Excel with shortcut?
2:18 How to unhide window in Excel with shortcut?
2:29 How to hide window in Excel with command?
2:39 How to unhide window in Excel with command?
2:49 How to hide sheet in Excel?
3:04 How to unhide all sheets in excel vba?
Description:
How to hide row, column, window and sheet in Excel (unhide all sheets with VBA)
One. Excel hides rows and columns and unhides them
How to hide row in Excel?
If we want to hide the third line. Click the row number 3 on the left side of the third row to select it, right-click it, select "Hide" in the pop-up menu, the third row is hidden, and there is a gap between the second row number and the fourth row number.
How to unhide row in Excel?
Move the pointer to the lower line of the gap, the pointer will then change to a double horizontal line and double arrow shape, at this time, right-click, select "Unhide" in the pop-up menu to redisplay the hidden third row.
Another way
Select the upper and lower rows of the hidden row, that is, select the second and fourth rows, right-click them, select "Unhide" in the pop-up menu, and the third row will be displayed again.
How to hide multiple rows in Excel?
Select the third row first, hold down the Ctrl, and then click the row numbers before rows 4, 9, and 10 to select them, right-click on the selected row numbers, and select "Hide" in the pop-up menu, then all the selected rows are hidden.
How to unhide multiple rows in Excel?
Press Ctrl + A to select all rows of the table, right-click on the selected row numbers, and select "Unhide" in the pop-up menu, then the hidden rows 3, 4, 9, and 10 will be redisplayed.
How to hide column in Excel?
1. The method of hiding and unhiding columns is similar to the method of hiding and unhiding rows; When hiding a row is exactly the same as when hiding a column, the cancellation method is exactly the same; When hiding multiple columns, press Ctrl + A to select all columns, then right-click, and then select Unhide to display the hidden columns.
2. Steps: click B to select column B, hold down Ctrl, then click C and D, select columns B, C and D, right-click C, and select "Hide" in the pop-up menu, then the selected columns are hidden; Select column A and column E, right-click E, select "Unhide" in the pop-up menu, and the hidden columns B, C, and D will be displayed again; Press Ctrl + A to select all, right-click E again, and also select "Unhide", then the three columns B, C, and D are also displayed.
Two. Excel hides and unhides workbook windows
How to hide window in Excel with shortcut?
Press and hold Alt, pressing W and H once. the workbook window is hidden.
How to unhide window in Excel with shortcut?
Press and hold Alt, pressing W and U once, open the Unhide window, select the workbook we want to cancel, click OK, and the workbook window reappears.
How to hide window in excel with command?
Select the View tab, click Hide above the Window, the workbook is hidden, and Hidden becomes gray and not selectable.
How to unhide window in excel with command?
Click Unhide to open the Unhide window, select the workbook window that we want to unhide, click OK, and the workbook window reappears. When the workbook window is hidden, all workbooks (Sheets) are hidden.
Three. Excel hides and unhides sheets
(1) Hide and unhide a sheet
Suppose we want to hide Sheet1. Right-click "Sheet1" in the lower left corner, select "Hide" in the pop-up menu, then Sheet1 is hidden, at this time, automatically display its right "Sheet3".
How to unhide sheet in Excel?
right-click "Sheet3", select "Unhide" in the pop-up menu, open the "Unhide" window, select "Sheet1", click "OK", then Sheet1 is redisplayed.
(2) How to unhide all sheets in excel vba?
1. Unhiding all sheets at once needs to be implemented with macro VBA. Press Alt + F11 to open the macro editing window, if the Module editing window does not appear, click Insert tabl, and select Module in the pop-up menu.
2. Enter the following code in the module editing window:
Sub ShowSheets()
For Each Sheet In Sheets
Sheet.Visible = True
Next
End Sub
3. Demonstration. Switch to the Excel window, hide the three sheets, switch to the VBA window, press F5 to execute the code, and the three hidden sheets are displayed again.
Watch video How to hide row, column, window and sheet in Excel (unhide all sheets with VBA) online without registration, duration hours minute second in high quality. This video was added by user Loinsure 09 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 455 once and liked it 1 people.