Excel Weekly News from Contextures Feb 11, 2014

Show pivot labels in every row + more Excel tips

In this week's Excel news, you'll see how to show pivot labels in every row, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Find Last Item in Group With Index Match

The MATCH function can find the postion of an item in a list, and INDEX can return the contents of the cell in that position. In this example, the INDEX/MATCH formula finds a category in one column, and returns the last code for that category, from another column

Click here to see the details: Find Last Item in Group With Index Match

Turn Repeating Item Labels On and Off

In Excel 2010 and later versions, you can change a pivot table setting, so the item labels appear in every row, instead of just once, at the top of the group. This can be useful if the lists are long, so you can't see the headings as you scroll down. You can also do lookups from the pivot table, if the names are filled in.

Click here to see the details: Turn Repeating Item Labels On and Off

Put Add-in Buttons on Excel QAT

To make the Ribbon commands easier to use, you can add a few to the Quick Access Toolbar (QAT). You can even add commands from your favourite add-ins, like my Excel Tools. Also, you can select a specific workbook, and show a command on the QAT only when that file is open.

Click here to see the details: Put Add-in Buttons on Excel QAT

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

Online Courses

Video: Quickly Insert Blank Rows

Watch this very short video to see a quick way to insert several blank rows in a worksheet, using a mouse shortcut.

Quiet Spot in the Forest

One of the places that I visited on Hilton Head Island, South Carolina, was the Shell Ring, in the Sea Pines forest preserve. Historians believe that this was a gathering place for ceremonies and feasts, for the people that lived there, long ago. If you look closely, you can see a bench at the bottom right of the picture. It's normal sized, so that should give you some idea of how tall those trees are!


Contextures Products

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


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.