Excel Weekly News from Contextures Mar 11, 2014
Drag pictures into Excel + more Excel tips
In this week's Excel news, you'll see how to drag pictures into an Excel file, and other tips. Thank you for reading the Excel news!
- Debra email@example.com
Dragging Pictures in Excel
You can drag images from the web into Excel, but you can't drag in a picture file from Windows Explorer. Maybe this feature will be added one day, but for now, here is a workaround that you can use, if you're trying to add an image to a worksheet.
Click here to see the details: Dragging Pictures in Excel
Stop a Pivot Table Refresh
After you add new items to a pivot table's source data, you need to refresh the pivot table, to see the updates. If multiple pivot tables are based on the same data source, updating one will update all of them. You can also stop an update, if it's taking too long.
Click here to see the details: Stop a Pivot Table Refresh
Which Excel Function Are You?
You've probably seen those online quizzes, such as "Which Star Wars Character Are You?" You can create something similar in Excel, and in this example, you'll find out which Excel function you are.
Click here to see the details: Which Excel Function Are You?
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- Mynda Treacy used Excel to design an amazing Minecraft themed cake for her son's birthday party. Read the comments too, to see what unusual things other people have done with Excel.
- Felienne Hermans, an assistant professor at Delft University of Technology based in the Netherlands, explains why spreadsheets stink, and 4 ways to improve them
- Doug Jenkins, explains how he fixed a problem with UCase and LCase in VBA
- MF Wong shows how to create drop down lists with employee names sorted by the number of hours they've been assigned.
- 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.
Video: Allow Some Changes on Protected Sheet
In some worksheets, you might want to allow users to make changes in specific cells, while keeping the rest of the worksheet locked. This short video shows the steps for setting that up.
Keep Your Distance
I snapped this picture at a nearby park, where there were several alligators swimming and lying in the sun. The big one was probably 8-10 feet long, and you can just see the nose of the smaller alligator on the left. And trust me, I was pretty far away from them when I took this photo!
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.