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 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. Drag-n-drop columns? - Why not? 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 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 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 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 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 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. 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