You can switch columns and rows in Microsoft Excel using the Transpose function. It works with a formula we'll show you here or by using paste options.

Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.

It is really easy to unhide all rows and/or columns in Excel, but make sure that the cells are not frozen and the sheet is not locked.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Interested in learning about how to freeze rows and columns in Excel? If so, then our step-by-step guide has got you covered.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Splitting data into multiple columns isn't the only way to rearrange data in Excel. For example, you could merge data from two columns into one column, split alternate rows into two columns, or ...