Learn Excel - Simplify Life with Excel Concepts

Excel COLUMNS Function

COLUMNS Function

How to use the COLUMNS Function (WS)

This Excel tutorial explains how to use the Excel COLUMNS function with syntax and examples.


The Excel COLUMNS function returns the count of columns in a given reference.

For example,

  • COLUMNS(A1:C3) returns 3, since the range A1:C3 contains 3 columns.


To get the number of columns in an array or reference.


The COLUMNS function returns number of columns. It returns a numeric value.




The COLUMNS function syntax has the following arguments:

  • Array: Required. An array or array formula, or a reference to a range of cells for which you want the number of columns.
    • A reference to a range of cells.


  • Use the COLUMNS function to get the column count for a given reference or range.