There may be times you want to eliminate a row or column from a spread sheet, but you do not want to permanently erase it from the worksheet file. Excel has a function that allows you to briefly conceal a row or column from sight.
NOTE: Cells in surprise rows as well as columns can still be included in calculations in other noticeable cells in addition to carry out calculations themselves.
To conceal one or more rows, select the row(s) to be hidden.
Right-click on among the row headers selected and pick Hide from the popup menu.
The selected rows are concealed, including the row headings. Notification that rows 3 and also 4 in the adhering to picture are hidden as well. A thick line also initially separates the rows where there are surprise rows. When you carry out various other actions on the spread sheet, this thick line will certainly vanish. Nonetheless, you can tell where the rows are concealed by the missing out on row headers.
To unhide a row, you have to initially pick the rows both above and also below the hidden row(s). Then, right-click on the chosen row headers as well as pick Unhide from the popup food selection.
The concealed rows show once again and also are highlighted along with the bordering rows.
You can also easily conceal one or more columns. Select the column(s) you intend to hide, right-click on one of the column headers, as well as select Hide from the popup food selection.
The chosen columns are hidden along with the column headers and also a thicker line display screens where the columns were.
To unhide the covert columns, just like with surprise rows, choose the columns both to the right and also left of the surprise columns, right-click on one of the column headers, as well as pick Unhide from the popup menu.
The hidden column(s) display again highlighted in addition to the columns on either side.
This function is handy if you intend to publish out just relevant rows and also columns of your spreadsheet, however do not wish to remove the momentarily unwanted details.