Download the add-in to add the between columns
Click on the following link to download the add-in.
Next, copy the file to Excel's Add-ins folder. The default folder is
C:\Users\UserName\AppData\Roaming\Microsoft\AddIns
Of course, you must customize the path according to your computer by changing the UserName value
In addition, Microsoft has tightened security by systematically blocking downloaded files. To unblock the file, follow these steps.
Install the add-in
Next, you need to go to the developer tab.
If this menu is not in your ribbon, it must be displayed
- From the File > Option > Custom ribbon
- Then check the box for the Developer tab
From the Developer menu, open Excel Add-ins menu
If you have successfully copied the file to the Excel Add-ins folder, the name of the utility should appear in the list of add-ins.
All you need to do is click on the Gototablecolumn add-in to activate it
If the add-in doesn't appear in the list, click on the Browse button, then select the GoToTableColumn.xlam file
How do I use the add-in to move to a specific column?
To quickly move between columns in a workbook, it is essential that your data must be inserted in a Table (Insert > Table). This is because in a Table, each column is identified by a unique name. Like that, the add-in will be able to "read" the names of the columns in your Table.
Once the add-in is activated, you just have to do
- Select one of the cells in a Table
- Right-click to open the contextual menu
- Then, you select the Go To menu (in the third position in the contextual menu)
- Choose one of the columns from the list
And instantly, Excel takes you to that column 😀👍
