Excel | pivot table | pivot tricks 4 | #excel #pivot #exceltutorial

Instead of dragging the fields one by one to clear and start over the pivot table, This is the smartest way and time efficient to, By using the clear option in the pivot design tab. To know more about pivot table and excel please join us @buildfromblank

[HamidrezaFereidouni-zr]

I have to move many variables in pivot table to "values", "Rows", and "Columns" areas. Moving them one by one to each part is very time consuming. I would appreciate it if you could let me know if there is any way to move multiple variables simultaneously to, for instance. Rows area?