
1. Keep the cursor on row or column go to page setup, you can use shortcut key for page setup “Alt+P,S,P”
2. Click on “Sheet” keep the cursor in the box of Rows to repeat at top, now select the rows which you want to repeat; use shift+arrow keys to select rows and thank “ok”
3. Do the same for column, keep the cursor in the box of Columns to repeat at top, select the column and click “Ok”
4. This will automatic apply rows and column on every page of Excel Sheet
No comments:
Post a Comment