Convert to Range tool is not active

Occasional Visitor

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. 

gordvera_0-1647606651795.png

gordvera_1-1647606711488.png

 

 

1 Reply

@gordvera 

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.