Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

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.

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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

How to Link Rows Together in Excel. In addition to storing typed data in each cell of a spreadsheet, Microsoft Excel allows you to perform functions on one cell and show the result in another cell ...

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 ...

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.