Use this tab to change the layout of the current worksheet. This is also known as pivoting. For example, you might want to change which items are displayed, and their position on the worksheet.
For more information, see:
"About pivoting worksheet items"
"About designing workbooks for maximum performance".
Use this check box to display page items on the worksheet.
This area shows which items are displayed in the Page Items area on the worksheet.
This area shows how the items are arranged.
To change an item's position, click the item and drag and drop it to a new location. To help you position items, as you move an item round the worksheet a black line is displayed showing its new location.
To remove an item, click the item and press Delete.
If you remove an item from a worksheet (for example, by selecting an item and pressing the Delete key), you also remove items that are dependent on the item (for example, calculations, conditions). For example, if you remove an items called Sales SUM that is used in a calculation, the calculation is also removed.