You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Select » Select cell in selection where value changes
This utility selects the cell in a selected range where the value changes.This is helpful when dealing with a large number of adjacent cells with the same value in a column and you want to "jump" down to the cell where the value changes.
Screenshots
Starting this utility
In the Excel menu choose: ASAP Utilities » Select » Select cell in selection where value changes« Return to the list of “Select” tools.
| « Previous Extend selection to the last used column | Next » Select cells with the smallest number |
You can do this too
Download "The one essential add-in for all Excel users."
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
