Add an icon set to a range in Excel 2007. Episode 922 shows you how.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
I could never figure out why Excel 2003 doesn't offer a paste picture icon or a close all icon. You can get to these obscure menu items, but when you try to drag them to the toolbar, they revert back to just paste or close. I will muse about this in Episode 896 with a possible explanation.
Seven ways to paste values in Excel. While I talk about many ways to convert formulas to values, Don from Orrville has come up with a method shorter than the other 6 methods I usually discuss. So...drumroll please... Episode 877 with method #7 for doing Paste Values!!!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Kim asks about the minus minus in certain formulas. In Episode 899, I will break one of those formulas down and show exactly why people use the minus minus.
In Episode 898, I show off some of the deep features in Excel 2007 pivot tables and offer a sincere thank you to everyone at MrExcel.com.
While I've shown how to drag and drop data on a chart, that method doesn't work if your chart is on a different worksheet than the data. Today in Episode 897, a trick to add new data to an existing chart.
Today is the 10th anniversary of MrExcel.com, so I am repeating my all-time favorite trick. Episode 895 shows you how.
Rod sends in today's question. He has to export several tab-delimited text files for a third-party application. He has the data for each file on a separate worksheet in a workbook and would like a macro to save those worksheets as individual text files. In Episode 894, I record a simple macro, then edit it to solve Rod's problem.
Eric asks how to customize icons for his macros on the Excel 2007 Quick Access Toolbar. In Episode 893, I will take a look at this feature in Excel 2003 and the limited options available in Excel 2007.
