Move columns, delete blanks, simplify more than ten common tasks in Microsoft Excel

We can choose the simple way
over the complicated one

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?

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.

Filter by selection

Filter by selection,
delete blanks in a click

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.

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 to use
it in your formulas

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.

Lock selection for other worksheets

Sync selection when
switching between sheets

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

Visualize your tables

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

Download now and see how it can help you