USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Pivot Table Fields
|
|
|
handles
|
|
|
legend keys
|
|
|
Fill
|
Detailed explanation-1: -Click anywhere in the table. Go to the Table tab on the Ribbon. In the Table Style Options group, select the Header Row check box to hide or display the table headers. If you rename the header rows and then turn off the header row, the original values you input will be retained if you turn the header row back on.
Detailed explanation-2: -Method #1: Show the Pivot Table Field List with the Right-click Menu. Probably the fastest way to get it back is to use the right-click menu. Right-click any cell in the pivot table and select Show Field List from the menu.
Detailed explanation-3: -The PivotTable Fields list has two tabs − ACTIVE and ALL that appear below the title and above the fields list. The ALL tab is highlighted. Note that the ALL tab displays all the data tables in the Data Model and ACTIVE tab displays all the data tables that are chosen for the Power PivotTable at hand.