Contextures

Contextures News 20190430

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!

Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Create an Excel Table from a List

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:

  • easy to set up
  • makes it easy to sort, filter, format, and expand your list.
  • refer to the table's fields in your formulas, and the reference will adjust automatically, if you add or remove data.

sort table data

To see the details, and a short video, click here: Create an Excel Table from a List

Highlight Duplicate Records in an Excel List

If you want to look for duplicate records in an Excel list, you can use conditional formatting to highlight them.

highlight duplicate records

To see the details, and a short video, click here: Highlight Duplicate Records in an Excel List

Show Multiple Grand Totals in an Excel Pivot Table

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.

Multiple Grand Totals

Click here, to read the details, and to see the short video: Show Multiple Grand Totals in an Excel Pivot Table

Video: Turn Off Paste Options in Excel

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.

Contextures Products

Save time with our "Done For You" Excel products.

Ice Storm Photo

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!

weekly photo

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.

Debra Dalgleish
dsdalg@ gmail.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: April 28, 2019 4:13 PM