Hiding Rows and Columns—and Getting them Back Excel 2010

You can also hide rows and columns—not so much in order to maintain the secrecy of your data, but to
i mpr ov e  the  a ppe a r a n ce  of a  spr e a dshe e t; pe r ha ps col umn s wi th compl e x for mul a s don ’ t n e e d to be 
seen—but if you  do hide them, all the data posted there remain active, and any cell references to them
remain in force, too.
To start hiding, click on any cell or cells in a column or row you wish to hide and click Home  
Cells button group Format   Hide & Unhide   Hide Rows  or   Hide Columns (Figure 7–4):

Figure 7–4. Outta sight: where to start hiding rows or columns

Click and the rows or columns will disappear, as will the column letters and/or row numbers of the
hidden items. To hide several rows or columns at the same time, just drag across those columns or drag
down those rows, leave that selection in place, and click the commands you see in 7–4.
Now sooner or later you may want to reveal these clandestine areas of the workbook—and to do
so you need to select rows or columns on  either side  of the hidden ones. For example, if the K column is
hidden, just drag across any row in the J and L columns (e.g., J23:L23), leave that selection in place, and
click the command sequence as per Figure 7–4—only here you’ll click either Unhide Rows, or  in our 
ca se  Unhide Columns.
Now on to multiple worksheets, because extra space on your single worksheet may not be what
you want