• Easy Territories in Excel Pivot Tables

                   

    You pivot table has a list of cities, but no Territory field: There is an easy way to create a virtual Territory field: 1) Select the cities in the first territory (Click on first city, Ctrl+Click on others) 2) In the Pivot Table Tools ribbon, click Group Selection. 3) By default, they call the territory(…)

    View 2 Excel Workbooks Side by Side where both Scroll!

                   

    Need to see two workbooks side by side?   With both workbooks open, go to the View tab and click View Side by Side. This column of 3 icons are the first to shrink on this ribbon tab, so most of the time it is a tiny unlabeled column as you see on the right.(…)

     

The MrExcel Archive

Learn Excel from MrExcel