Today, Wayne from Kentucky points out that you can quickly adjust Column Widths using the Paste Special Column Widths tool. He laments that there is not a similar tool for copying Row Heights. In Episode #1393, Bill shows us how to copy Row Heights as well.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today we look at changing font color automatically after editing a cell. We know that we could use F4, the Format Painter or a Excel VBA [Visual Basic for Applications] Macro - Using Excel VBA create a macro to add a red font color automatically after editing a cell. In Episode #1392, Bill shows us all three of these techniques for formatting our data.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Mrs. Schleuter's seventh grade computer apps class wanted to figure out how many columns there are between A and XFD. In an effort to find the answer and to introduce her students to the Best Excel Resource available, Mrs. Schleuter went to the "MrExcel Message Board"! Today, in Episode #1391, Bill re-introduces the MrExcel Message Board as a source for answers concerning all things Excel - plus an answer as to how to calculate the number of columns between A and XFD!

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Kelly wants to display a Range in a Pivot Table. Unfortunately, Calculated Fields in a Pivot Table look at each individual row, so the MAX(B2)-MIN(B2) will always be zero. PowerPivot and the DAX Measure come to the rescue here and in Episode #1390, Bill shows us how its done!

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Dueling Excel #76 looks at Creating a Table of Contents for your workbook. Hyperlinks that work within the confines of your workbook allowing you to navigate throughout. Today, in Episode #1389, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen show us how to make Navigating a Workbook easier using both manual and coded means. Learn a few shortcuts, learn a little VBA and see how easy all of it is!

Dueling Excel Podcast #76…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Today's Learn Excel from MrExcel Podcast, Episode #1388, comes from contacts on Facebook: "If a formula is checking to see if a date is today, and you have to add a second condition, use the AND function"...Also...another way to select a hyperlink cell without activating the hyperlink. And...why boolean formulas sometimes return 0 or 1 instead of False or True.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today, in Episode #1387, Bill H. asks, "How do I change a date/time field from midnight to 6PM?" Since Microsoft Excel stores time values as a Fractional portion of a day [where a day is = to 1], MrExcel shows us how to change our time values using Paste Special - a quick and efficient solution!

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

One of the old tricks in Microsoft Excel is adding a pop-up picture to a cell. I showed this a long time ago on an episode of TechTV. The VBA code that I used back in Excel 2003 to add the pop-up pictures is no longer working in Excel 2010. Today, with Episode #1386, Bill shows us how to update the code for use in Microsoft Excel 2010.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

In a previous Learn Excel from MrExcel Podcast [Episode #1375] Bill created a UDF [User Defined Function] as an Excel Macro to Join Text. Lon liked the User Defined Function that Bill was using and decided to make use of it. Upon attempting to move the Macro to his PERSONAL.XLSB Excel Workbook, Lon discovered that the Excel Macro would no longer work. "?"

Today, in Episode #1385, Bill shows us two (2) workarounds that address and correct this issue and create a Personal Excel Add-in in the process! Follow along! It's easy and fun to do!

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Duel #75! Another Dueling Podcast with Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen. Today, in Episode #1384, Mike and Bill revisit the Invoicing question from Episode #1379: "Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?". Using the set up from Episode #1379, today's Duel focuses on adding Dynamic Validation and Dynamic VLOOKUP using OFFSET or INDEX. Follow along with Episode #1384 - Duel #75! - and let Mike and Bill show us how it's done!

Dueling Excel Podcast #74…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Chris R writes in today to ask "Why does Excel sometimes automatically perform Text to Columns when pasting data from another application. In Episode #1383 Bill will explain under what conditions this will happen and how to turn it off or on.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Mike is looking for a faster way to Find. He wants to enter his search term in a Named Cell and have a Macro that will search for that term. Today, in Episode #1382, Bill shows us how to Record a Macro and edit that Macro to do the job we need done.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

There are 96 Quarter Hours each day and each day [according to Microsoft Excel] is equal to "1". Why do we need to know this? Because today, in Episode #1381, Bill takes a look at Quarter Hours in Excel. Michael asks, "How can I group a Pivot Table up to Quarter Hours?" Unfortunately, there is no ideal way to do this in the Pivot Table or in PowerPivot, but Bill shows us how to add a Formula to the original Data Set to solve the problem.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today, in Episode #1380, Bill looks at the =RANK Function. Excel 2010 makes it easy to Rank a Column in a Pivot Table. Although...the way that Pivot Tables handle ties is different than how the RANK function handles ties. Watch the podcast and learn a bit about =RANK.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today's Dueling Podcast Question: "Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?" In Episode #1379, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen take a look at using Table Nomenclature in Validation and in VLOOKUP.

Dueling Excel Podcast #74…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.