Excel Tip -Select Pivot Table Options

****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com ----------------------------------------­--------------------------- Website http://www.howtoexcelatexcel.excel.com Twitter https://twitter.com/howtoexcelatex Pinterest http://www.pinterest.com/howtoexcelat If you use Pivot Tables regularly and you either move them around, select parts of them or indeed all of them, then here is a really quick method for selecting areas of your Pivot with ease...with the Pivot Table Enable Selection options in Excel. First of all you need to ensure that the Enable Section is turned ON. To turn it on, 1. Select a cell in the Pivot Table 2.On the Pivot Table Tab- selection Options 3.In the Actions group -Click Select 4.Check if Enable is ON or Off The difference is the small coloured square around the Enable Selection option. Once the enable selection is turned on you can use the Selection Arrow to select the entire Pivot Table. To select the entire pivot table, including the report filters: 1.Point to the top border of the top left cell, in the body of the pivot table. 2.When the pointer changes to a thick black arrow, click, to select the entire pivot table.