Print rows with column headers on top of every page
If a worksheet spans more than one page, you can print row or column headers or labels (also called print titles) in the first row or mutliple rows on every page.
Insert, move, or delete page breaks in a worksheet
Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert. To print a worksheet with the exact number of pages that you want, you can adjust the …
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. Follow these steps to add Print Titles to a worksheet:
Lock or unlock specific areas of a protected worksheet
To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet. Follow these steps:
Page Setup - Microsoft Support
Use the Page Setup dialog box to set up layout and print options of a page. Click on the Page Layout tab, then in the Page Setup group, click the Dialog Box Launcher.
Headers and footers in a worksheet - Microsoft Support
Excel has many built-in text headers and footers that you can use. For worksheets, you can work with headers and footers in Page Layout view. For chart sheets or charts you need to go through the Page Setup dialog box. Select the worksheet where you want to add or change a built-in header or footer.
Split panes to lock rows or columns in separate worksheet areas
Select the column to the right of the column where you want to place the split, and use the Split command. You can also split on both a row and a column. by selecting the cell below and to the right of where you want the split—then click Split.
Scale a worksheet - Microsoft Support
If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page. Follow these steps: Click the Page Layout tab on the ribbon.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Print row and column headings - Microsoft Support
By default, Excel doesn't print the column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) that appear along the borders of the sheet. Follow these steps to print the column and row headings for a worksheet:
Find or replace text and numbers on a worksheet
You can search by rows and columns, search within comments or values, and search within worksheets or entire workbooks. Tip: You can also use formulas to replace text. To learn more, check out the SUBSTITUTE function or REPLACE, REPLACEB functions .