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 firstname.lastname@example.org
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
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
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
Here are a few of the Excel articles that I read last week, that you might find useful:
Watch this very short video to see a quick way to insert several blank rows in a worksheet, using a mouse shortcut.
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!
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, click
on the links to take a look at their features, and decide if they're
right for you.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.