Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

WRAPCOLS

WRAPROWS WRAPCOLS

By Jeff Lenning | March 3, 2026 |

Sometimes when we copy data into Excel—from websites, reports, or bank statements—it doesn’t arrive in a nice, neat table. Instead, it comes in as one long line of values, either in a row or a column. That’s where WRAPROWS and WRAPCOLS come in. Video Tutorial In this post, we’ll explore how to use these functions…