Then press Ctrl + Shift + 9 keyboard combination to unhide all rows, or press Ctrl + Shift + 0 to show all hidden columns. If you want to unhide all rows or columns on a sheet, make sure the whole worksheet is selected. Part 3: Quickly Unhide All Hidden Rows or Columns Right-click the selected column headers and pick Unhide. To unhide a column, select the columns before and after the hidden columns. Then, right-click on the selection and click Unhide from the popup menu.
HIDE PRINT LINES EXCEL 2016 HOW TO
Since row 3 is hidden, we want to select rows 2 to 4. How to Hide Gridlines in Calc in LibreOffice, Chapter 5,Learning Excel, Replace,Filter, Align Text, Remove Gridlines, Hide a sheet in excel, How to Hide Gridlines in Excel (Remove. To unhide a row, just select the row above and the row below the hidden row. Part 2: Unhide a Whole Row or Column in Excel 2016 But you’ll see double lines at column or row headers, which indicates a column or row is hidden. The selected row or column will be hidden from view straight away.Right-click the selected row or column, and then click the Hide option.If you wish to hide an entire column, click the column letter to select it.