MrExcel Excel Videos

Donna from Colorado asks how to clear all of the input cells from a model. In today's Where Is It Wednesday Episode 868, we take a look at how to select only the numeric constants. Also - following up on 858 - Copy as Picture, 860 Resizing Header Logo, 863 Protect Sheet.

If you need to make an exact copy of formulas, you can use the method from episode 866 or this Fill Across Worksheets solution. Episode 867 shows you how.

Markus from Germany sends in this tip. Say that you have to make an exact copy of a range of formulas. It is like you need to do a CUT and PASTE, but also leave the original cells where they were. Normally, a Copy and Paste will rewrite the formulas. Using this trick from Markus, you can achieve the desired result. Episode 866 shows you how.

Taylor from Orange County California calls in to ask how you can get the formatting of a pivot table to stick? Every time that you refresh a pivot table, the formatting reverts back to a default. The bad news is that you can not make all formatting stick, but Episode 865 will show you a couple of methods to use.

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!

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.