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!
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.
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
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.
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.
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!
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.
- 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.
- Most spreadsheet cell references are relative, so if you copy them to other cells, the references change to reflect the new location.
- 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.
- Quickly check out formulas by enabling the Track Cells utility.
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.
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
See how the add-in can help you
You can view the video in the fullscreen mode by clicking
Quick Tools for Microsoft Excel screenshots
Simply drag-n-drop columns to move them
Filter the table by the value you select
Delete blank rows and columns from Excel worksheet
Perform range calculations in a click
Copy range address to use it in your formulas
Convert your formulas to values and change reference type
Sync selection when switching between sheets
Visualize your tables','Visualize your tables
Quick Tools for Excel system requirements:
- 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
- Microsoft Excel 2003
- Windows 10 (32- and 64-bit)
- 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 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
Quick Tools for Excel version
Current add-in version: 3.1
published on: May 19, 2016
End-User License Agreement (EULA).