DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which feature do you use to repeat column A on every page when printing a multiple page worksheet?
|
|
Print Titles
|
|
|
Page Break Preview
|
|
|
A header
|
|
|
Custom margins
|
Explanation:
Detailed explanation-1: -Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].
Detailed explanation-2: -To do this, select the cell that contains the content you want to repeat. Then, click and drag the fill handle (the small square in the bottom-right corner of the cell) until all of the cells you want to fill are selected. The contents of the cell will be copied into all of the selected cells.
There is 1 question to complete.