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. Since row 3 is hidden, we want to select rows 2 to 4. 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. Select the whole row you want to hide by clicking the row number.Part 1: Hide a Whole Row or Column in Excel 2016 How can I hide a full column in Excel worksheet without deleting it? If you don’t want others to see a specific row or avoid printing a certain column, you can hide the entire row or column in Excel 2016.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |