USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Home
|
|
|
Page Layout
|
|
|
Formulas
|
|
|
Data
|
Detailed explanation-1: -The More Paper Sizes displays the “Page Setup” dialog box, Page tab. Print Area-Drop-Down. This drop-down contains the commands: Set Print Area and Clear Print Area.
Detailed explanation-2: -In an Excel Worksheet, in the Sheet Optionssection of the Page Layout tab of the ribbon, you clear the Print box option under Gridlines. You copy a part of that worksheet to your clipboard.
Detailed explanation-3: -The Page Layout Tab holds all the options that allow you to arrange your document pages just the way you want them. You can set margins, apply themes, control of page orientation and size, add sections and line breaks, display line numbers, and set paragraph indentation and lines.
Detailed explanation-4: -Navigate to the Toolbar and select the Page Layout option. Once you click on the Page Layout option, you will find the Page Layout Ribbon, as shown in the image below.
Detailed explanation-5: -On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK.