hold the Ctrl and select the row or column numbers. In Excel, rows run horizontally across the spreadsheet and range from 1 to 1048576. Rows are identified by the numbers on the left side of the row.

Then, from the Ribbon menu that appears at the top of the Excel Sheet, select ‘Page Layout ... Setup dialog box and then delete the row and column ranges from the ‘Rows to Repeat at Top ...

Excel's customization features enable you to standardize the appearance of your data. Select the ... for the last row in the series. Alternatively, click and drag through the range of headings ...