WebApr 26, 2024 · Yes, that's possible! Try this code: Private Sub Worksheet_Change (ByVal Target As Range) If Range ("B3") = "1" Then Rows ("10:15").EntireRow.Hidden = False ActiveSheet.PageSetup.PrintArea = "$A$1:$H$15" Else Rows ("10:15").EntireRow.Hidden = True ActiveSheet.PageSetup.PrintArea = "$A$1:$H$9" End If End Sub 0 Likes Reply … WebOct 23, 2009 · Sometimes when one person opens the spreadsheet, all hidden columns/rows reappear. However, if someone else opens the same spreadsheet, the columns/rows remain hidden. What can be causing the columns/rows to unhide for some people and not for others? Ultimately, we would like the columns/rows to remain hidden …
Unhide All Rows Not Working in Excel (5 Issues & Solutions)
WebDec 19, 2024 · Hide Columns in Excel Using a Keyboard Shortcut The keyboard key combination for hiding columns is Ctrl+0. Hide Separated Columns Hide and Unhide … WebNov 19, 2024 · I want to select the following by clicking or adding a value next to the item using a simple alphanumeric value or even a checkbox. This is done on Sheet 1. Once … google full screen
Why can
WebTo unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows . Tip: If you don’t see Unhide Columns or … WebOct 31, 2024 · Select the columns that are adjacent to the hidden column. You’re really selecting three columns: the hidden column and both columns on either side of it. After selecting the hidden... Web2 days ago · I don't usually use Excel and am struggling. I have a mailing list that I have to send to a printer, but I first need to remove "hidden rows," and the instructions I was given are: Go to "File." Select "Info." Then "Check for issues." And "Inspect "Check "Hidden Rows and Columns" and . Click "Inspect." Under "Hidden Rows and Columns," Click ... google full form in computer