Discussion
In MS Excel, Print Titles on the Page Layout tab is used to
Answer: B
Correct answer: repeat chosen rows or columns on every printed page
Print Titles repeats chosen rows or columns on every printed page - typically the header row of a long table, so that a reader of page seven still knows what each column contains. It is set from Page Setup on the Page Layout tab, where Rows to repeat at top and Columns to repeat at left take a reference such as $1:$1. It is frequently confused with Freeze Panes, and the distinction is worth fixing: Freeze Panes affects only the screen and has no effect whatever on printing, while Print Titles affects only printing and does nothing on screen. A long table usually wants both. The neighbouring print controls are worth knowing together. Print Area restricts what is printed. Fit to scales the sheet to a set number of pages. Page Break Preview shows and lets you drag the page boundaries. And Print Gridlines and Print Headings add the grid and the row and column labels, neither of which prints by default.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development