Repeat specific rows or columns on every printed page

To repeat specific rows or columns on every printed page in Excel (great for keeping headers visible), follow these steps:

✅ Repeat Rows or Columns on Every Printed Page

1. Open your Excel worksheet.
2. Go to the Page Layout tab on the Ribbon.
3. Click Print Titles in the Page Setup group.
4. In the Page Setup dialog that appears:
   • To repeat rows at the top, click the field for Rows to repeat at top, then select the row(s) you want to repeat (e.g., row 1: =$1:$1).
   • To repeat columns at the left, click the field for Columns to repeat at left, then select the column(s) you want to repeat (e.g., column A: =$A:$A).
5. Click OK.

🖨️ Preview It:

• Go to File → Print (or press Ctrl + P) and check the preview to confirm the rows/columns repeat on every page.

💡 Notes:

• You can repeat multiple rows or columns by selecting a range (e.g., =$1:$2 or =$A:$B).
• Useful when printing large tables that span multiple pages.