Excel News 20130416
April 16, 2013
In this week's Excel news, you'll see how to show multiple grand totals in a pivot table, highlight duplicate records, and other tips. Thank you for reading the Excel news!
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Instead of a simple list, use a formatted Excel table for extra features. A table is a great data source for a pivot table, and has many benefits:
To see the details, and a short video, click here: Create an Excel Table from a List
If you want to look for duplicate records in an Excel list, you can use conditional formatting to highlight them.
To see the details, and a short video, click here: Highlight Duplicate Records in an Excel List
Did you know that you can show multiple subtotals or grand totals in an Excel pivot table? For example, you can show Sum, Average and Max at the bottom of your pivot table, or in the subtotals.
Click here, to read the details, and to see the short video: Show Multiple Grand Totals in an Excel Pivot Table
When you copy and paste in Excel, you might see option boxes, at the bottom right of the pasted data. You can click those buttons, to select an option for pasting the data, such as Paste Values.
If you don't like those boxes, and never use them, watch this video to see the steps to turn this feature off.
Note: If you're using Excel 2010 or Excel 2013, click the File tab, instead of the Office button.
Save time with our "Done For You" Excel products.
Did you get the ice storm in your area last week? Just when we thought that spring had finally arrived here in Canada, another blast of winter blew through. Here's a picture of the neighbour's vines, coated with ice, after this week's ice storm. Everything looked sparkly and lovely, but it sure was treacherous to move around out there!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2013/20130416B80xr.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: April 28, 2019 4:13 PM