peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Filter Pivot Table Source Data in Excel

When you're analyzing data in an Excel pivot table, you might want to see the detail behind one of the numbers. To extract the data, you can double-click a data cell and a new worksheet is created, with the related records.

This is a nice feature, but you'll end up with extra sheets in your [...]

Related Posts Plugin for WordPress, Blogger...