Easy-XL From MrExcel - Latest Version

The latest version of Easy-XL From MrExcel is 5.0.504

Click here for a list of recent enhacements.

Updates are free to users with current support or who are currently running version 5.

To update your version of the software, uninstall your current version and then download and install the latest version. Reactivation is not required. Instructions and download links can be found HERE.

To find out which version of Easy-XL you are using, use Excel -> Easy-XL -> Help -> About

To purchase or renew support, login to your account, locate your Easy-XL From MrExcel software purchase and click the "Add / Renew Support" link.

Here is the account login link:

http://www.easy-xl.com/login

Your account number and password were emailed to you when you purchased. If you have misplaced the original message then please let us know and we'll resend the information to you.

Easy-XL From MrExcel Version 5.0.504

January 2013

Supports Excel / Office 2013.

The "Rows -> Tag Rows" menu has been moved to its own top level menu on the ribbon.

Row tagging now supports user defined tags in addition to a simple + sign.

Added the "Combine Tagged Rows" command to combine multiple rows based on tag type.

"Tag Rows By Column Value" now supports regular expressions

The "Import -> Import ODBC Tables" command now supports the use of a Where command to specify which rows to import.

The "Cells -> Convert Selected Cells" drop-down menu has been replaced with a floating dialog with a preview function.

Added the new Worksheet menu

Added the "Combine Sheets" command to the new Worksheet menu.

Moved the "Duplicate Sheet" command to the new Worksheet menu.

Moved the "Cells -> Format Sheet" command to the new Worksheet menu.

Moved the "Sort To Sheet" command to the new Worksheet menu.

Added the "Add Row #" command to the "Columns -> Arrange Columns" dialog.

Added "Remove Blank Columns" to the Columns menu.

Added "Remove Blank Rows" to the Rows menu.

Added "Duplicate Column" to the Columns menu.

Added "Duplicate Row" to the Rows menu.

Added "Insert N Columns" to the Columns menu.

Added "Insert N Rows" to the Rows menu.

The "Columns -> Column Properties" command has been renamed and moved to "Cells -> Selected Cell Properties".

The new "Columns -> Column Properties" command analyzes all of the columns in the worksheet and highlights potential problems including blanks and mixed data type issues (text cells mixed with numeric cells).

The "Workbook Navigator" has been redesigned.

Easy-XL From MrExcel Version 5.0.503

December 2011

Improved support for non-English versions of Windows and Excel

Index Workbooks now lists all of the external links in a workbook

Easy-XL From MrExcel Version 5.0.502

June 2011

Easy-XL From MrExcel Version 5 contains the following updates:

Support for Excel 2010 including the ability to handle huge amounts of data with the 64-bit version.

Merge a worksheet into an existing worksheet - Merge has been enhanced to allow you to insert the desired data into the existing worksheet with no need to create a separate worksheet.

Row View - For very wide worksheets, this displays the column values in a stacked (vertical) format on a tool window allowing you to see all of the data values on a row without having to scroll left and right.

Quick Find - Right-click a cell and you'll see a new menu item: Find 'xxx' In... where 'xxx' represents the current cell's value. Selecting this option allows you to select the specific worksheet in which you'd like to search for the value. This feature is useful for reconciling rows between different worksheets based on things like account number, name and address.

Insert n Rows or Columns - Right-click the row # (or column #) in Excel and you'll see a new menu item: Insert n Rows (or columns) When you insert with regular Excel, you have to do it one row (or column) at a time. This pops up a dialog asking you how many rows (columns) to insert.

Regular Expression Functions

Workbook Index now indexes macros (VBA) - There's now an option to include a detailed listing of all the macros found while indexing workbooks. The list includes all of the modules, components, classes, subroutines and functions contained within the workbook's VBA project.

Numerous tweaks and minor bug fixes.

Full support for Terminal Server, Remote Desktop Connection and Citrix.

Full support for Win 7 (32 and 64-bit)

Full support for Windows Server 2008 R2

Full support for Unicode

MrExcel Podcasts

Learn Excel from MrExcel Video Podcast
Learn Excel from Bill Jelen with this daily 2 minute video podcast!
  • "Don't Fear The Spreadsheet" - Import Text File to Excel: Podcast #1622

    Today, in Episode #1622, Tyler needs to get some Text files into Excel. Fortunately, Text files may be imported into Excel and there are options as to how they are formatted as the Data is being introduced to your Spreadsheet. Follow along with Bill today as he shows us different ways to Import Text files into Excel.

    Many ‘Beginner Oriented’ Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel – Don’t Fear The Spreadsheet’ actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner – Tyler Nash – with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up – Kevin Jones, Tom Urtis and Bill Jelen.

    “The Learn Excel from MrExcel Podcast Series”

    Visit us: MrExcel.com for all of your Microsoft Excel Needs!

  • Learn Excel 2013 - "Charting in Excel 2013": Podcast #1621

    Instead of following the standard marketing techniques, Bill departs the norm to show you what HE has found in Excel 2013 and tells you how you can see it LIVE yourself – today! http://tinyurl.com/xl13preview

    Microsoft has improved the Charting process with Excel 2013. today, In Episode #1621, Bill shows us:

    Recommended Charts

    Combo Charts - New Interface

    Cool Chart Styles in the paintbrush icon

    Charting unsummarized data

    Charting data with extra subtotals using the Filter icon

    Oh and a side note; while Bill had promised to show us Chart Labels from Formulas today, he ran out of time in this episode. He will tackle that one in the near future.

    And if you want to get a look at Excel 2013 for yourself and take it for a test-drive, for a *Limited Time*, try out Office 2013 Home Premium! Visit http://tinyurl.com/xl13preview . Click the ‘Excel logo’ at the bottom, then Office 365 Home Premium on the right, then ‘Try It’ to download a trial for up to five PC’s! http://tinyurl.com/xl13preview Get started today!

    Learn Excel 2013 from MrExcel Right Here on the “Learn Excel from MrExcel” blog!

    Be Sure to visit MrExcel.com for All of your Microsoft Excel needs!

  • MrExcel Says "Try Excel 2013-See Excel 2013 Live! Try It Today!": Podcast #1620

    Bill has been writing for 4 months. What has he been writing about? Excel 2013 Of Course. So instead of following the standard marketing techniques, Bill departs the norm to show you what HE has found and tells you how you can see it LIVE yourself - today!

    Today, in Episode #1620, Bill reveals the first of his 12 best, "Under-The-Radar" features in Excel 2013: Slicers on a regular Worksheet. Also, a look at the Color Schemes and Backgrounds.

    ***Special Note To Viewers***

    And if you want to get a look for yourself, for a *Limited Time*, try out Office 2013 Home Premium! Visit http://tinyurl.com/xl13preview. Click the 'Excel logo' at the bottom, then Office 365 Home Premium on the right, then 'Try It' to download a trial for up to five PC's!

    Get started today!

  • Learn Excel from MrExcel - "OFFSET for a VLOOKUP Table": Podcast #1619

    Today's question comes from Ron and he would like to know, "when would I use OFFSET in conjunction with the VLOOKUP Function?" In Episode #1619, Bill "MrExcel" Jelen explains the use of OFFSET and VLOOKUP together as well as provides us a great example.

    …This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

    “The Learn Excel from MrExcel Podcast Series”

    MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

  • MrExcel At The ModelOff Championships - "Sum / Average Multiple Criteria": Podcast #1618

    Bill ’MrExcel’ Jelen: [Almost] Live From New York City to judge the ModelOff Worldwide Excel Championship! With 16 Excel Rock Stars, from around the Globe, in NYC – and Bill having access to them all – why not do some Podcasting OnSite!

    Today, Bill is with Matijn Reekers for our last 'Almost Live from The ModelOff championships" series. In Episode #1618, Bill and Matijn are looking at Summing and Averaging Multiple Criteria in Excel. 

    "What Does 'Control + R' do?" Find out!"

    ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year’s competition, visit http://www.modeloff.com/modeloff-2013/

    ...This blog is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html 

    "The Learn Excel from MrExcel Podcast Series"

    Visit us: MrExcel.com for all of your Microsoft Excel Needs!