All the rows which were hidden should now become visible at the same time.Right-click and select the “Unhide Rows” option.Select the row headers for all the rows in the range.Tip: If you don't see Unhide Columns or Unhide Rows, make sure you're right-clicking inside the column or row label. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. To unhide column A, right-click the column B header or label and pick Unhide Columns.
In the message that appears requesting your confirmation to unlock it, click OK.Right-click the column header and select Unlock Column (or click the lock icon under the column header).How do you unlock columns in Google Sheets? Select how many rows or columns to freeze.Select a row or column you want to freeze or unfreeze.On your computer, open a spreadsheet in Google Sheets.How do I unfreeze columns in Google Sheets? If you can not see the option "Unhide Rows", it means there are no rows hidden. Select all rows and the row number column on the far left will turn dark gray. If you're on a desktop, another way to unhide is to select a range of column on either side of the hidden column, right-click, and choose "Unhide Columns." Why can't I unhide rows in Google Sheets? To unhide it on desktop or mobile, just click or tap the small arrow on either side of the hidden column or row. How do you Uncollapse columns in Google Sheets? Now column A should be unhidden in your Excel spreadsheet. Select Cells > Format > Hide & Unhide > Unhide Columns. Select the Home tab from the toolbar at the top of the screen. Related Question How do I unhide columns in sheets? How do I unhide column A? Right-click anywhere in the worksheet area.This will select all the cells in the worksheet. Click on the small triangle at the top left of the worksheet area.