Forum Discussion
gordvera
Mar 18, 2022Copper Contributor
Convert to Range tool is not active
I was trying to conert a Pivot table into a range following the instuctions here Convert an Excel table to a range of data (microsoft.com) but for some reason it´s not there and when I add it manually, the funcion is not active.
1 Reply
Sort By
Convert to Range applies to tables created by clicking Table on the Insert tab of the ribbon, not to pivot tables.
You can do the following instead:
- Select the entire pivot table.
- Copy it.
- Click the lower half of the Paste button on the Home tab of the ribbon and select Values.