Forum Discussion
Convert to Range tool is not active
I was trying to conert a Pivot table into a range following the instuctions here https://support.microsoft.com/en-us/office/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77 but for some reason it´s not there and when I add it manually, the funcion is not active.
1 Reply
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.
