Episode 896 - Paste Picture Icon

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.

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!

Episode 441 - Paste Formulas

Eric from Shanghai writes in with a question about adding a Paste Formulas icon to the standard toolbar in Excel. While Excel only offers custom buttons for Paste Values and Paste Formats, Episode 441 will help you discover how to get a Paste Formulas icon on your toolbar.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 424 - Toolbar Hyperlinks

More tricks for your Excel toolbars, including how to edit the icons or how to add an icon to the toolbar that opens a particular webpage, perhaps www.MrExcel.com! Episode 424 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 422 - Customizing Toolbars

Learn some new tricks with your Excel 97-2003 toolbars. Add new buttons for common tasks. Paste icons from other applications. Add words next to existing buttons. Episode 422 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 406 - Color Sort

New in Excel 2007 - you can sort by cell color! Today's episode takes a look at the new Sort dialog in Excel 2007. You can sort by more than three levels, and also choose to sort by font color, cell color, or icon. Episode 406 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Episode 388 - Org Charts

Create an Org Chart in Excel. The org chart tool is hidden behind an obscure icon on the drawing toolbar. The details of using the tool are a bit complicated. Episode 388 shows you how to create an org chart.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 356 - Customizing Icons

You probably know that you can add new icons to your Excel toolbars, but did you know that those icons can also come from Word or PowerPoint? Episode 356 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!