If your workbook contains sensitive data and you do not want the data to get exposed then you may hide the rows or columns. 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.
To hide a row, click on the cell first. In Home tab, click Format, hover the mouse over Hide & Unhide and finally click Hide Rows.
To unhide a row, the above and below row to the hidden row must be selected first. From the Home tab, click Format, hover the mouse over Hide & Unhide and finally click Unhide Rows. 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.
To hide a column, click on the cell first. In Home tab, click Format, hover the mouse over Hide & Unhide and finally click Hide Columns.
To unhide a column, select the columns that are just left and right to the hidden column and then from the Home tab, click Format, hover the mouse over Hide & Unhide and finally click Unhide Columns.
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)
