From simpler data entry and faster cell selection to quicker analysis and better dashboards, Excel has useful features even ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...

When working with business data, you may encounter grouped data that needs to be divided into multiple columns. As an example, you might have a customer list that groups first and last names in a ...

Excel’s shiny new functions still can’t dethrone the PivotTable.

If you’ve ever worked with an enormous Excel spreadsheet, you’ll know just how daunting all those rows and columns can be. Once you’re over 10 or 15 different values and labels, it can get pretty ...

Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in ...

Microsoft Excel has lots of features that can help you manage your data. For example, say you have a hundred cells, which are each filled with a first and last name. You can use the "Text to Columns" ...

Learn the many ways to insert entire and partial rows and columns in Excel, including a fill handle method. Out of necessity, you probably learned early on how to insert rows and columns. Both are ...

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here’s how. We all inherit Microsoft Excel sheets that don’t suit our working ...