Real Life Problem:
In Corporate Office, there is a common problem, if you are going to print a complete employee list, then it will go for 2nd page. Or any data or report which takes more than 1 pages, then a question is in mind, "how to print the row title or column title on each sheet"?
Example Data Table:
Assume that A1:D40 is the data table, where A1 = Employee Name, B1 = Designation, C1 = Salary, D1 = Date of Joining. And A2:D40 contains the 39 records of 39 employees.
Solution:
To print the row and column title on each sheet, you don't need to re-design the table. In Excel you can do it through "Page Setup" dialog box.
1) Go to sheet tab from this dialog box
2) Click on Rows to repeat at top and click on the row number which you want to print as header on each page.
3) Do the same thing for Columns to repeat at left text box.
4) Make sure the page setup
5) Finally click on Ok button to set it.
6) Then use print command to print it.
In Corporate Office, there is a common problem, if you are going to print a complete employee list, then it will go for 2nd page. Or any data or report which takes more than 1 pages, then a question is in mind, "how to print the row title or column title on each sheet"?
Example Data Table:
Assume that A1:D40 is the data table, where A1 = Employee Name, B1 = Designation, C1 = Salary, D1 = Date of Joining. And A2:D40 contains the 39 records of 39 employees.
Solution:
To print the row and column title on each sheet, you don't need to re-design the table. In Excel you can do it through "Page Setup" dialog box.
1) Go to sheet tab from this dialog box
2) Click on Rows to repeat at top and click on the row number which you want to print as header on each page.
3) Do the same thing for Columns to repeat at left text box.
4) Make sure the page setup
5) Finally click on Ok button to set it.
6) Then use print command to print it.
Image 1: Print titles settings in Page Setup dialog box
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw