Skip to content

How to Use Excel TOCOL Function?

Listen to this article.
TOCOL FunctionPin
TOCOL Function

Excel TOCOL Function: Sometimes, we want to convert the array of data into columns, we can manually do this by copying the values and pasting them on the specified cells to make a column. This is quite frustrating to you. For that, Microsoft Excel provides a built-in function called “TOCOL” for making it possible with a few clicks.

To use Excel TOCOL Function on your worksheet, refer to the below-given steps. You can easily apply this function and make a column using a range of input data in the spreadsheet. Get an official version of MS Excel from the following link:

Excel TOCOL FunctionPin
Excel TOCOL Function

Definition of TOCOL Function

  • It is one of the built-in functions in Microsoft Excel.
  • The TOCOL function transforms the given array into a single column in the worksheet.
  • By default, the TOCOL function will scan values by row. It can also scan values by column.


  • Here, you will see the syntax of the TOCOL function.
  • To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
  • Once you enter the formula, click on the Enter button to get the result.

=TOCOL (array, ignore, scan_by_column)

Argument Explanation:

  • array – The array to transform.
  • ignore – Setting to ignore blanks and errors.
  • scan_by_column – Scan array by column. TRUE=column, FALSE=row (default=TRUE).


Let’s look at some practical examples of the TOCOL Function and explore how to use it in Microsoft Excel.

  • Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
  • For instance, we have given a range of values as shown in the below screenshot. And we will transform them into a column using TOCOL function.
Input RangePin
Input Range
  • Then, you have to enter the formula in the cell as shown below to get the result.
Enter the formulaPin
Enter the formula
  • After entering the formula, you need to click the Enter button to get the output.


From this post, you can clearly understand how to use the Excel TOCOL function in the worksheet using its syntax. The given examples helped you to understand this function even easier. Drop your comments regarding this post in the below section. To learn more about Excel functions, then visit our webpage

Video Tutorial

The following video will show you how to use the Excel TOCOL function in the spreadsheet.

Read Also:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...