6] Shift the Excel cell down with Insert Copied Cells Select a range of cell, right-click and select Copy . Click the location that you want the data to go, then click the Home tab.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

Selecting "Up to row 4," for example, will freeze the first four rows And to freeze a column, use the options in the same dropdown menu: No columns: This acts as an "undo" button for any freeze ...

Note: When you delete cells in Excel, the data below it will be moved up. 6. Once all the blank rows are highlighted, go to the Home tab and locate the Delete button on the right-hand side.

How to freeze the top row in Excel Keep in mind that this doesn't have to literally be the top row in your spreadsheet — this command lets you freeze the first visible row. 1.