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

Chapter 1. Getting the Most Out of Ranges > Other Go To Special Options

Other Go To Special Options

The Go To Special dialog box includes a few more options to help you in your range-selection chores:

OptionDescription
Last CellSelects the last cell in the worksheet (that is, the lower-right corner) that contains data or formatting.
Visible Cells OnlySelects only cells that are unhidden.
Conditional formatsSelects only cells that contain conditional formatting.
Data ValidationSelects cells that contains data-validation rules. If you click All, Excel selects every cell with a data-validation rule; if you click Same, Excel selects every cell that has the same validation rule as the current cell.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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