GoTo Pro; Enhanced GoTo Special - for Desktop, Web And Teams Excel
Content
What is GoTo Pro
GoTo Pro is a free add-in which offers two tools: It allows you to use GoTo Special in Web and in Teams Excel and it has a Worksheet finder. GoTo Pro is free of charge and works in Excel on-line, Excel for Windows and Mac 365, both 32 and 64 bits.
What makes GoTo Pro special is that it allows you to use GoTo Special in Web Excel. It also has a handy worksheet finder useful when your workbook has many worksheets.
Installation instructions
Web and Teams Excel
Use this button to install GoTo Pro for your Excel on-line (it should then automatically also become available in Teams). After clicking the button, a new Excel file will open with this information:
Click the "Accept and Continue" button in the task pane to start using the add-in.
If my website button does not work, open any Excel file in your browser and click the add-ins button. Then search for gotopro:
Click Add to add the add-in to your Web Excel.
Desktop Excel
Use this button to install GoToPro for desktop Excel.
After clicking that button, the browser will ask permission to open Excel. Click Open and Excel will start and display this:
Click the "Accept and Continue" button in the task pane to start using the add-in.
If my button does not work for you, you can also install the tool by opening Excel and clicking Add-ins (On the Home tab):
To add GoToPro to your Excel, click the Add button.
Donate
If you like GoTo Pro, please consider donating to help support it's future development:Instructions
First launch
After installing the add-in, the Explorer pane opens and displays the About tab, with information about the tools and features of the add-in:
This pane can be reopened by clicking the Explore button on the ribbon. Note there are tabs at the top of the pane allowing you to choose which tool you want to use. GoTo Pro will remember the tab you had active and if you reopen the pane it will automatically open with that tab selected.
The About tab shows information about the tool and allows you to add some made-up data to your workbook to play with the GoTo Special feature. Click the "Insert training data (new sheet)" button to get a newly inserted worksheet with this information for you to play with:
GoTo Special
To use GoTo Special, simply click the GoTo Special button on the Home tab (or in the Explore task pane):
If you happen to have the single line ribbon, click the three dots on its far right to find the GoToPro buttons:
This familiar looking dialog will open:
It works the same as the desktop version.
Note how the underlined characters indicate which button on your keyboard you can press to activate options. Example: To find Formula cells, press the F key.
If no matching cells or objects are found, the dialog stays open and displays a message:
Objects
When you use the Objects box, GoTo Pro doesn't select the objects. Instead, it selects the top-left cell of each object. After closing the dialog you can use the TAB key to jump from one object to the next.
Find a Sheet
Click the Find a Sheet tab to get a list of all your worksheets. Filter the list by typing (part of) its name in the Find box. The list auto-updates as you type. Press the Tab key to jump to the list where you can use the up and down arrow keys (and the Home and End key) to navigate the list of sheets. Pressing Enter or Space bar selects the sheet in question.
Change history
- Version 1.1.0.0, 2025-11-19
- Added 'Dirty Formula Cells' to the GoTo Special dialog.
- Added descriptive tooltips to all SpecialCell categories.
- Fixed bug: Selecting Precedents did not enable 'Direct Only' and 'All Levels' options
- Build 1.0.0.0, 2025-11-12
- First release
Updating
If you are not sure you are using the latest version, click inside the GoTo Pro pane and press control+F5 to ensure the latest version of GoTo Pro is fetched from our server. The build number is listed close to the bottom of the Explore pane, About tab.
For Web Excel: Open your browser settings and clear its cache. Then close all browser windows and re-open it.
Comments