Microsoft Office Tutorials and References
In Depth Information
Select the rows or columns you want to hide and
choose Home>Cells>Format>Hide & Unhide>Hide
Rows or Hide Columns (see Figure 11-20).
Optionally, right-click over a selected column or
row and choose Hide.
Select All Hidden rows Hidden columns
Hidden columns or rows.
When you are ready to unhide rows or columns,
select the rows or columns on both sides of the
hidden rows or columns. If you have hidden
column A or row 1, you cannot select columns or
rows on both sides. In this situation, click the
Select All button to the left of column A and above
row 1. Choose Home>Cells>Format>Hide &
Unhide>Unhide Rows or Unhide Columns. Again,
you can optionally right-click the selected rows or
columns and choose Unhide.
Select the columns or rows you want to hide.
The selected rows or columns remain hidden. In
Figure 11-21, columns D, E & F are hidden from view.
Sometimes worksheets become quite
large, making locating particular pieces of
information time-consuming and difficult. If
your data is in an array, you may find the data
easier to view if it is sorted in a particular manner.
Perhaps you have multiple worksheets, and you
want to locate every occurrence of a specific value.
Or, maybe you’re just a neat freak and want
everything to be in a particular order. Excel contains
features to help your arrange your worksheets in an