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 perfoming formula operations
  • Synchronizing selection on different sheets
  • Inserting picture comments in a click

Complete support for:

Quick Tools for Excel - simple calculations in the entire range, and other useful one-click utilities.

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 "Apply" button. So next time you need to subtract 10% from all your prices - just select them, choose the operation and click Apply!


Get cell or range address

Copy range address

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

29.95
Buy now

See how the add-in can help you

You can view the video in the fullscreen mode by clicking fullscreen icon

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

Free Download
Free 15-day trial version, 11/6/2013

Quick Tools for Excel system requirements:

Operating System

  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 2.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

Microsoft Excel

  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Quick Tools for Excel version

Current add-in version: 2.2.3
published on: Nov 06, 2013

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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
Awesome!!!
Sheila Blanchard