Microsoft Office Tutorials and References
In Depth Information
Hiding Rows and Columns
Figure 5–47. Where to hide columns or rows
Your worksheet will then exhibit a gap
where the hide was executed, as shown in
Figure 5–48.
Figure 5–48. Row 11 isn’t there, but its data is still
The second technique for hiding columns and/or rows is as follows:
Select what you want to hide.
6. Click the Home tab, and
then choose Format Hide
& Unhide Hide Rows or
Hide Columns from the Cells
button group (see Figure
Figure 5–49. An alternative way to hide columns or
NOTE: The second technique lets you select columns/rows to be hidden either by clicking on
column or row headings or clicking anywhere in the column(s) or row(s) you want to hide.
Search JabSto ::

Custom Search