Kerry asks: after adding automatic subtotals, how can you copy only the subtotal rows? Episode 731 will show you how. 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!
Joe Marten sends in a better way to limit the number of characters entered in a cell. Episode 599 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! For(…)
In yesterday’s podcast, I showed how to rearrange one column. But – what if you need to rearrange all of the columns? Episode 544 shows how to use a little known sorting trick to sort the columns back to the original sequence. This blog is the video podcast companion to the book, Learn Excel from(…)
Do you need to turn data on its side in Excel 2007? PowerPoint MVP Kathy Jacobs shares her favorite new feature in Excel 2007. Episode 472 show you how.
You are invited on Monday to download MrExcel’s NCAA bracket and enter his free NCAA pool. The winner will get their choice of books from the MrExcel store. In today’s Episode 461, we will take a look at the Data – Validation commands used to make the NCAA bracket selection worksheet work. This blog is(…)