Product Details

Getting Started With Easy-XL from MrExcel

Use the Open Getting Started Guide option on the Help menu to open the gettting started guide. This guide contains a quick introduction and has examples that you can work through using the included sample data.

Use the Open Easy-XL Sample Workbook on the Help menu (On the Workbooks Menu for Excel 2000 - 2003) to open the sample data. This workbook contains various worksheets that you can use to experiment with Easy-XL.

Excel 2007 / 2010

For Excel version 2007 and 2010, the Easy-XL ribbon menu appears along the top of Excel's ribbon menu next to the Data ribbon item. You can access the classic 2000 thru 2003 menus on Excel's Add-Ins ribbon item and then selecting Easy-XL. You can also right-click on any cell within Excel to access this menu.

Excel 2000 - 2003

For Excel versions 2000 thru 2003, the Easy-XL dropdown menu appears along the top of Excel's main menu bar next to the Data option. You can also right-click on any cell within Excel to access this menu.


Easy-XL's Features

Site Login

Shopping Cart

MrExcel Podcasts

Learn Excel from MrExcel
New Excel Tips & Tricks Every Weekday!
  • Excel Filter by Selection
    There is a great Filter by Selection icon in Access. Excel offers the same functionality, but it is hidden and mislabeled! To add the command to your Quick Access Toolbar: Right click the QAT Choose Customize Quick Access Toolbar From the top left dropdown, change from Popular Commands to All Commands In the left listbox,(...)
  • Convert Excel Dates to Month Names
    Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format. Try these: =TEXT(A2,”MMMM”) for full month name =TEXT(A2,”MMM”) for 3-letter month abbreviation =TEXT(A2,”DDDD”) for full month name =TEXT(A2,”DDD”) for 3-letter month abbreviation You can use any valid custom(...)
  • Excel Fill Alphabet or Roman Numerals
    Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III? For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down. For the lower case alphabet, use =CHAR(ROW(97:97)) For upper case Roman numerals: =ROMAN(ROW(1:1)) For lower case Roman numerals =LOWER(ROMAN(ROW(1:1))) Tip: After filling any of these,(...)
  • Excel Search Entire Workbook
    You need to find something, but you don’t know what worksheet it is on.   Display Find with Ctrl+F Click the Options > > button. Open the Search dropdown and change from Sheet to Workbook.
  • Copy Excel Worksheet – Easy and Fast
    You’ve created the perfect report for January. Now you need to make 11 copies for the other months. Hold down the Ctrl key. While holding down the Ctrl key, click on the sheet tab and drag to the right. You should see the mouse pointer change to an arrow pointing to a sheet with a(...)