The row height in spreadsheets increases and decreases according to the data’s size entered into the rows; Excel will automatically increase and decrease the rows.

Excel allows you the flexibility to move columns and rows into blank cells of the same size and filter the data in your spreadsheet to view selected records.

How to Change Columns Into Rows in Excel 2007. If you've ever entered a long list of business data and realized you need this information across a row instead of down a column, you can take ...

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.

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.