You want to Repeat specific rows or columns on every printed page,
1. Open your project in Excel and click the Page Layout tab.
2. Click Print Titles and enter the rows and columns that you want to repeat at the top and left of each page.
3. Click OK and then click Print to see the preview.
Detail Step with screenshot
Click on Excel Ribbon, choose
Explore My Other Channel for More Cool and Valuable Insights
π Youtube Learn Tech Tipsπ Tiktok
π Facebook:Page Layout -> Print Tittles -> Choose Tab Sheet
Choose “Rows to repeat at top” / "Columns to repeat at left" -> drag mouse to the position which you need to repeat (So common is header file) -> Press ok for confirm
Thank you for reading this post. I hope you found it helpful and easy to follow. If you have any feedback or questions about
How to "read and write file with right format wi ,
please share them in the comments below. I would love to hear from you and discuss this topic further
✋✋✋✋
Webzone Tech Tips, all things Tech Tips for web development
- I am Zidane, See you next time soon ✋✋✋✋