• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Advanced Formatting and Editi... > Selecting Only Visible Cells

Selecting Only Visible Cells

When you collapse part of an outline, Excel hides the columns or rows that you don't want to see. In Figure 9-33, for example, the detail columns are hidden for Q1. Normally, if you select a range that includes hidden cells, those hidden cells are included in the selection. Whatever you do with these cells also happens to the hidden cells, so if you want to copy only the displayed totals, using copy-and-paste gives you the entire table. By choosing Edit, Go To, clicking the Special button, and selecting the Visible Cells Only option, you can restrict the selection to only the visible cells within a range.

The Select Visible Cells option is ideal for copying, charting, or performing calculations on only those cells that occupy a particular level of your outline. Select Visible Cells works the same way in worksheets that have not been outlined; it excludes any cells in hidden columns or rows from the current selection. This very handy option is available in button form, but you need to add it to a toolbar first, such as the one described in the “Creating an Outlining Toolbar” sidebar on page 270.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint