Hiding Columns and Rows in Excel
In Excel, you often need rows or columns of data to perform
an operation that you don't necessarily want to display. Or perhaps you
want to print the spreadsheet, but you have confidential information
that you do not want to print. One solution to problems like these
is hiding the appropriate rows and columns. Select the columns (or rows) that
you want to hide. Then choose Columns (or Rows) from the Format
menu. Choose Hide from the sub menu that appears. The selected
columns (or rows) are hidden. Notice the letter headings on the
columns below. The left image shows all columns. The image on the
right has had columns B and C hidden. The letter headings go from A
to D. This is an indication that columns have been hidden. In
some later versions of Excel (2000 and 2002), there is an additional
indication of hidden rows or columns. The line between A and D is a
heavier line than normal. (This doesn't appear in Excel 95 or 97.)
Once you have hidden rows or columns, you need to know how to
unhide them. The process is similar. The main difference is that you
must select the column (or row) to either side of the hidden columns
(or rows). Then choose Columns (or Rows) from the Format menu.
Choose Unhide from the sub menu that appears.
Return to Top
|
