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 |