MrExcel Excel Videos

Back in Episode 578, I used an incredibly complex method using NotePad for joining cells together. Today, Jonathan from the UK points out that a few lines of VBA code would have made the solution incredibly simple. Episode 587 shows you how. Function ConcatenateRange(rCells As Range) Dim vTemp As Variant Application.Volatile For Each vTemp In rCells ConcatenateRange = ConcatenateRange & vTemp & " " Next vTemp End Function 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!

Here is another solution to Episode 585: Instead of trying to limit how much data the person can type into a field, you can use the Shrink to Fit setting to reduce the font size to allow all of your information to appear. Episode 586 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!

Ron from Dallas asks how he can limit the number of characters that will fit in a certain cell. Episode 585 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!

Store your validation lists on a separate worksheet and have the dropdown boxes automatically expand when you add new items to the list. Episode 584 shows you how. If you'd like to try this out, download the sample workbook. Monday in the USA is our Labor Day holiday and I'll be back Tuesday, September 4th. 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!

Brent asks how you can set up validation lists on another worksheet. This is generally considered invalid, but Episode 583 shows you how to pull it off. 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!

Brent asks if it is possible to make the data validation dropdown arrow appear on the left side of the cell. In Episode 582, I show you a horrible way to accomplish this, that will be entirely unacceptable to 99.9% of the audience. 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!

Steve wonders how he can add a page break after every student in his gradebook. In Episode 581, I show an alternate solution, using the Page Setup. 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!

Susan writes in with an annoying problem. Crystal Reports is creating a report where every physical record is taking three rows in Excel. Episode 580 will walk through the steps necessary to get this into a nice sortable data set. 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!

Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games. In Episode 1041, I take a look at how to modify the original formula to calculate nothing until a score has been entered. 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!