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.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

In this podcast, former Motley Fool podcast host Chris Hill -- now host of the podcast Money Unplugged -- returns as a guest ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

If you are working with Excel files with hidden columns, it's important to learn how to unhide columns in Excel to extract maximum data.

Deleting columns in Excel is a straightforward task, whether you’re working on a single column or multiple ones. This process helps clean up your data and remove unnecessary information. Below is a ...

For flexibility, Microsoft Excel comes with the Transpose feature, which lets you switch columns and rows in Excel. The Transpose function in Excel changes your columns and rows’ orientation. It ...

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Excel's default color is already white, so you need only format every other column or row as gray to alternate between white and gray cells.

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.