O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14. Applying Reference, Information, and Text Formulas

Determine the Number of Columns in a Selection

You can use the COLUMNS function to determine the number of columns in a range. For example, suppose you keep a worksheet that contains name and address information for the members of a club, along with other miscellaneous information about each club member. You might want to use the COLUMNS function to determine the number of columns in your worksheet that contain membership information.

The COLUMNS function can also be very useful if you assigned a name to a range and you want to determine the number of columns in the named range; the COLUMNS function makes it very easy to determine this information.

You might also want to use the number ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required