Excel Weekly News from Contextures Feb 18, 2014
Add multiple items to a cell + more Excel tips
In this week's Excel news, you'll see how to click check boxes to add multiple items to a cell, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Stop AutoComplete From Copying Heading
Last week, I was working on a client file, and had trouble entering an "A" code in a column -- Excel was copying the heading text into the cell, as soon as I started typing. In every cell, I had to delete the unwanted text, before pressing Enter. See how I fixed the problem with AutoComplete, and what caused it.
Click here to see the details: Stop Unwanted AutoComplete in Cells
Find Pivot Table Source Data
If you update a pivot table, and it seems to miss some of the new records, you can check the source data. If it's a static range, you can adjust it, to include the new rows. Better yet, change the source to a formatted Excel table, so new rows are automatically included.
Click here to see the details: Find the Source Data for Your Pivot Table
Add Multiple Items to a Cell
With a drop down list, you can select an item to put in a cell. Add a bit of programming, and you can put multiple items in the cell, adding each one to the existing entries. In this week's sample file, it's even easier to put two or more items in a cell -- a listbox pops up, and you can check the items that you want to add.
Click here to see the details: Add Multiple Items to a Cell
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- Mitali Pattnaik wonders what kind of software could take Excel's place. You can add your opinion in the comments on her Disrupting Excel article.
- Jon Peltier shows how to create and update a chart, using only part of a pivot table's data.
- Recently, I shared a formula for finding the last item in a category, in a sorted list. Oscar created a formula that works with an unsorted list.
- If you're not sure what linear regression is, or how it works, read Mike Alexander's excellent, and easy to understand, explanation.
- You can select numbers on a worksheet, and see a Sum, Count, or other summaries in the Status bar. There's no Subtraction option, so Dick Kusleika created one of his own.
- Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- If you're near Tennessee, Rob Collie, from PowerPivot Pro, will be speaking at the first meeting of the Nashville Modern Excel User Group, on Thursday, Feb. 20th. The registration information is here, and there's free admission to the meeting.
- Chandoo has re-opened his Power Pivot online course, and you can find the course info and registration details here: Power Pivot Course
Video: Remove Custom Toolbar from Ribbon
If you open an Excel 2003 workbook that has an attached custom toolbar, those tools will appear on the Add-Ins tab in the Ribbon, in Excel 2007 and Excel 2010. This short video tutorial will show you how to remove them.
There are lots of birds on Hilton Head Island, South Carolina, like the cormorants in this picture. They like to sit in the sun, and spread their wings. There are a couple in the water in this shot, swimming and splashing. The one at the top of the post seems to think that he's the King of the World!
Recommended Excel Tools
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.
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.