Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

The procedure for freezing a row in Excel is very simple. You just need to be familiar with the program's toolbar. Click the row that you want to freeze. For convenience, we recommend filling out ...

How to Make Blank Rows Between Populated Rows in Excel. Spreadsheet applications like Excel enable you to insert, delete or rearrange entire rows of business data in ways that are difficult or ...

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

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.

If you want to hide and unhide columns and rows in Microsoft Excel, then know it is easier than you might have thought. We explain how.

In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.