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 413 - Mini Toolbar

Get quick access to all of the text formatting commands by moving your mouse towards the completely invisible mini toolbar! (Who at Microsoft comes up with this stuff?) Episode 413 shows you how to get the shy mini toolbar to appear.

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 398 - QAT Taming

The only toolbar that is easy to customize in Excel 2007 is the QAT or Quick Access Toolbar. Episode 398 shows you how to customize the QAT with your favorite icons.

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 376 - Select Visible Cells

When you have created automatic subtotals and want to format the subtotals rows, you will probably be visiting the Edit - Goto - Special - Visible Cells only setting. However, by customizing your toolbar, you can select the subtotals using a single button click. Episode 376 shows you how. Also - see how to move buttons on a toolbar without displaying the customize dialog.

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 371 - Tear-Off Pallettes

A little known trick in Office - how to force the dropdown pallettes from the toolbars to stay visible. Episode 371 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!