Skip to content
# EXCEL FUNCTION – COLUMNS

## How to use “COLUMNS” function in Excel

**Syntax:**

**Syntax Description:**

**Things to Remember:**

## Recommended Articles

## Similar Posts

### EXCEL FUNCTION – REPT

### EXCEL FUNCTION – PROPER

### EXCEL FUNCTION – MAX

### EXCEL FUNCTION – SMALL

### Excel Function – SUBTOTAL

### EXCEL FUNCTION- LEFT

=COLUMNS(array)

**array** argument is used to give the cell range for which total count of columns are required.

We will be using COLUMNS function as follows:

– If a single cell reference is given instead of cell range/array in array argument, then function output will be 1

– If cell reference is not correctly provided in the function, then it will give output as an error.

– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”

Don’t forget to leave your valuable comments!

REPT function is used to repeat the text or cell reference to multiple times

How to use Excel Function PROPER? PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which makes the function…

MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1

SMALL function is used to get the Smallest k-th value from the range.

SMALL Function has two required arguments i.e. array, and k

Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…

LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell