Excel Tip – Easy way to remove all value fields from your pivottable #excel
Excel Tip – Easy way to remove all value fields from your pivottable #excel
If you want to remove all your value fields from your pivot table – you should not do this by removing the fields one by one.
Instead of removing each field from the Values area in the PivotTable Fields action pane one by one – simply remove the Values field in the column or rows area.
Instead of removing each field from the Values area in the PivotTable Fields action pane one by one – simply remove the Values field in the column or rows area.
That will remove all your value fields from the pivottable.
Hope this little trick can help you too.
This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.