ExcelBytes
Share
Having worked in the bank for almost 13 odd years, I have come across various users with different levels of knowledge in Excel. In my opinion I feel many of our colleagues need some helping hand in Excel. I assure you that it is no big deal to start and learn Excel. Once you start referring to my posts, you will really start loving Excel. And I am sure, you will be able to handle certain official
Repating rows on all pages.
1. On the ribbon, click the Page layout tab.
2.Click Print Titles. The sheet tab of Page setup dialog box appears.
3. Click Rows to repeat at top option.
4. Now, click the row headers in the sheet which you want to repeat. Excel fills the address of the rows in the text box.
5. If you want more than one row, then select the required number of rows. But, be sure about the rows to repeat on the pages.
6. Click Ok. Thatz it.
7. Choose the print preview [Ctrl, f, w, v] option to verify that your rows are repeating.
Click here to claim your Sponsored Listing.
Category
Website
Address
Bangalore
