Quick Tools for Microsoft Excel

Move columns in your table, delete empty rows, filter data by selection and more

Quick Tools for Microsoft Excel is a set of 10 utilities that cut the clicks and greatly simplify your daily tasks. They make common operations not only quicker and easier, but actually enjoyable. Fewer clicks bring more results now!

  • Moving columns in your table by drag-n-dropping
  • Deleting all empty rows, columns and worksheets in a table
  • Quickly filtering data by selection
  • Running range operations and performing formula operations
  • Synchronizing selection on different sheets
  • Inserting picture comments in a click

Free download for:

Simply drag-n-drop  columns to move them

Less haste, more speed

Time always helps us find faster and easier ways to reach our goals. We work a lot in Excel and came across tasks that eat our time when we look up how to carry them out or follow the same steps again and again. So we figured we could make quick yet reliable tools to skip the unnecessary actions.

What we decided to do was to collect those daily tasks that require research or multiple tiresome steps, and to turn them into single-click tools. Below you can find a short description of each, and of course feel free to download the fully functional evaluation version to try the add-ins once and see how intuitive, simple and gratifying it is to work with them.

These ten utilities greatly simplify routine Excel operations

Drag-n-drop columns? - Why not?

Simply drag-n-drop  columns to move them

If your Excel table has over ten columns, changing their order can be a pain. Column manager is a simple tool to move a column to any place. The add-in opens up a list of all your columns with their headers. From here you can move them, autofit to their longest entries, or quickly navigate to any column.

Once you close the window you see a well laid out table with correctly ordered columns. Read more in How to: Manage Excel columns order

Filter by selection

Filter the table by the value you select

Instead of looking for the filter criteria in the long list of all possible values in your large worksheet, you can select a record right in your table and apply the Filter by Value tool for a quick review. You can select more than one value the same way; after applying the filter you'll only see the required information.

Delete empty rows, columns and worksheets

Delete blank rows and columns from  Excel worksheet

When managing data in Excel, empty rows and columns may hamper the progress. Clicking one button will delete all empty rows and columns in your table or worksheet. You can also remove all blank sheets you no longer need. Find more information here: How to: Remove blanks, apply filter by 1 click.

Calculate all numbers in the range

Perform range calculations in a click

Division, multiplication, addition and percentage calculation are not a problem if you have a couple of numbers. But what if you have to re-count entire ranges and tables of prices? You can make any basic calculations in the entire range by clicking the "Calculate" button. So next time you need to subtract 10% from all your prices - just select them, choose the operation and click Calculate!

Get cell or range address

Copy range address

When you need to refer to a range from another table, tick the External Reference option. Want to have the reference fixed - select Absolute. Then click Copy and you'll have the address in the Clipboard. Need to use it in your formula? Click Paste! It's that easy.

4 tools to work with formulas

Convert your formulas to values and change reference type
  1. Replace formulas with values each time you go through "copy -> paste special -> Values only", remember there is a button Convert to Value that does it all in a click.
  2. Most spreadsheet cell references are relative, so if you copy them to other cells, the references change to reflect the new location.
  3. If you have them as absolute, you can convert All to Relative. If you
    want to leave them unchanged instead, use the All to Absolute tool.
  4. Quickly check out formulas by enabling the Track Cells utility.
Read more in How to: Perform formula operations

Lock selection for other worksheets

Switching from one table to another and scrolling down to line 573 is not fun. Turn on the Sync Selection feature and each time you switch, the selection will stay the same.

Add pictures to comments

This tool turns 14 clicks into 1. Select a cell with your product name, click Insert Picture on the ribbon and browse for the product image. Visualize your tables with little effort. Find more in How to: Insert picture comments

Moving columns in Excel by drag-n-drop

Quick Tools for Microsoft Excel screenshots

Simply drag-n-drop columns to move them

Simply drag-n-drop  columns to move them

Filter the table by the value you select

Filter the table by the value you select

Delete blank rows and columns from Excel worksheet

Delete blank rows and columns from  Excel worksheet

Perform range calculations in a click

Perform range calculations in a click

Copy range address to use it in your formulas

Copy range address

Convert your formulas to values and change reference type

Convert your formulas to values and change reference type

Sync selection when switching between sheets

Sync selection when switching between sheets

Visualize your tables','Visualize your tables

Visualize your tables

This add-in comes as part of Ultimate Suite - 60+ professional tools for Microsoft Excel

Download and try Ultimate Suite without any limitations for 14 days.

Free Download
Free 14-day trial version, 13 MB

System requirements:

Microsoft Excel

  • Microsoft Excel 2016 (32- and 64-bit)
  • Desktop Excel included in Office 365
  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools - Ablebits.com