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

Chapter 1. Getting the Most Out of Ranges > Selecting Cells By Type

Selecting Cells By Type

The Go To Special dialog box contains many options, but only four of them enable you to select cells according to the type of contents they contain. Table 1.1 summarizes these four options. (The next few sections discuss the other Go To Special options.)

Table 1.1. Options for Selecting a Cell By Type
OptionDescription
CommentsSelects all cells that contain a comment
ConstantsSelects all cells that contain constants of the types specified in one or more of the check boxes listed under the Formulas option
FormulasSelects all cells containing formulas that produce results of the types specified in one or more of the following four check boxes:

Numbers— Selects all cells that contain numbers

Text— Selects all cells that contain text

Logicals— Selects all cells that contain logical values

Errors— Selects all cells that contain errors

BlanksSelects all cells that are blank



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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