The process for inserting rows is similar to inserting columns. Highlight the row (or single cell in the row) before or after which you want to insert new cells. Right-click the highlighted cells.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

Select Unhide Columns from the drop-down menu to reveal all hidden columns within your selection, or select Unhide Rows to do the same for rows.

How to freeze multiple rows and columns in Excel You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...

Selecting a cell that's below the first row will also freeze all prior rows. For example, if you select cell D5, you will freeze columns A, B and C; as well as rows 1, 2, 3 and 4.

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

How to unhide rows and columns in Excel Unhiding a row requires a bit more work than hiding them, because you must select a cell in the rows adjacent to the hidden rows.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.