Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.
Then the first column or row has been unhidden. Click OK to locate in A1, and then click Home > Format > Hide & Unhide > Unhide Columns/ Unhide Rows. Enable the sheet you want to display the first column or row, and press Ctrl + G to open Go To dialog, and enter A1 into the Reference textbox. To show hidden first column or row, you need to use Go to function to locate in A1, and then display the row or column.ġ. Show hidden first column/row with Kutools for Excel Show hidden first column/row with Go To function
However, if the first column or row whose two sides’ cells you cannot select is hidden, how can you display such column or row in Excel? In general, you can select the cells which are on the hidden column or row’s either sides, and then click Home > Format > Hide & Unhide to display the hidden column or row as below screenshot shown. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width.How to show hidden first column or row in Excel? Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. On the Home tab, in the Cells group, click Format. In the Reference box, type A1, and then click OK. On the Home tab, in the Editing group, click Find & Select, and then click Go To.
In the Name Box next to the formula bar, type A1, and then press ENTER. To select the first hidden row or column on the worksheet, do one of the following: Instead, you can use the Name box or the Go To command to select the first row and column. You can select the entire worksheet, and then unhide rows or columns ( Home tab, Cells group, Format button, Hide & Unhide command), but that displays all hidden rows and columns in your worksheet, which you may not want to do. If the first row (row 1) or column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that row or column.