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

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

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.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

When you split one of these merged cells, Excel restores all the rows and columns that make up the merged cell. It is possible for a merged cell to contain no text.

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.