![]() ![]() In Home tab, click Format, hover the mouse over Hide & Unhide and finally click Hide Columns. To hide a column, click on the cell first. For example, to unhide row 5, you have to click on any cell in row 4 and then press and hold the Shift key, click a cell in row6 and continue performing the unhide process. From the Home tab, click Format, hover the mouse over Hide & Unhide and finally click Unhide Rows. To unhide a row, the above and below row to the hidden row must be selected first. In Home tab, click Format, hover the mouse over Hide & Unhide and finally click Hide Rows. ![]() Hiding a row actually means that the height of the row is set to 0 and hiding a column actually means setting the width of the column to 0. If your workbook contains sensitive data and you do not want the data to get exposed then you may hide the rows or columns.
0 Comments
Leave a Reply. |