WebJun 5, 2024 · Select the column you want to protect. Choose Cells from the Format menu. Excel displays the Format Cells dialog box. Make sure the Protection tab is displayed. (See Figure 1.) Figure 1. The Protection tab of the Format Cells dialog box. Make sure both the Locked and Hidden check boxes are selected. WebThis help content & information General Help Center experience. Search. Clear search
Unhide the first column or row in a worksheet - Microsoft Support
WebThis help content & information General Help Center experience. Search. Clear search WebOct 14, 2015 · So unprotected, this is an easy fix... just group the three columns we want to hide (Columns Y:AA), and they can click the plus/minus sign. Note: I ONLY want there to be control over columns Y:AA. There are other hidden columns that I do NOT want the user to be able to unhide. But when the sheet is protected, they are not able to click those..... scrap prices red brass
Lock or unlock specific areas of a protected worksheet
WebOct 24, 2024 · Once you protect the sheet, it will not allow user to unhide columns. In case you want user to work on other columns/cells, then before protecting sheet, make other column/cells as Unlocked by going to cell format, last tab "Protection". Here you have to uncheck the Locked command. See this snip shot. Vijay 8 people found this reply helpful · WebMay 2, 2024 · To display all hidden rows in your spreadsheet, first, open your spreadsheet on Google Sheets. In your spreadsheet, select all your rows containing data. To do this, beside the first row, click the number “1.”. Then, scroll down until your dataset ends. Press and hold down the Shift key on your keyboard, and beside the last row, click the ... WebApr 16, 2016 · But the Problem is that I can't protect my sheet and make it work since I can't hide/unhide columns on protected sheets. You can. The easiest way is to protect the sheet with UserInterfaceOnly:=True. Sheet1.Protect Password:="abc", UserInterfaceOnly:=True Now you can hide/unhide the columns in a protected sheet. … scrap prices uk per kg