Aug 25, 2022 12:00 AM

New Excel functions - TOCOL and TOROW #shorts

External YouTube Channel

This Excel formulas and functions tutorial will show you how to use TOCOL and TOROW, the just launched new Excel function that lets you manipulate your table into new columns or rows.

TOCOL and TOROW are super easy to use and rolling out to Office 365 subscribers of Excel right now. To get TOCOL and TOROW today, sign up for Office Insiders at

Announcing New Text and Array Functions for Excel

I’m thrilled to share with you the availability of 14 new Excel functions designed to help you more easily manipulate text and arrays in your worksheets.

https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066

Excel TOCOL Handles 3D References And Ignores Errors

Today, a deeper dive into the new Excel functions TOCOL and TOROW.

https://www.youtube.com/watch?v=Zn32lzDuI6Y

Microsoft TOCAL

https://support.microsoft.com/en-gb/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed

Microsoft TOROW

https://support.microsoft.com/en-gb/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289