ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Binocular search tool, Excel, loses column designation at "Find" (https://www.excelbanter.com/excel-discussion-misc-queries/55710-binocular-search-tool-excel-loses-column-designation-find.html)

Little Rock Ette

Binocular search tool, Excel, loses column designation at "Find"
 
You have to re-designate which column(s) you are searching or the tool now
drops your column choice and searches the entire sheet. Thank you Bennie
Nicolo

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Dave Peterson

Binocular search tool, Excel, loses column designation at "Find"
 
That only happens if you click the Find All button.

So if you don't want to change the selection, don't click the Find All button.

If you just click Find, then the selection doesn't change.

Little Rock Ette wrote:

You have to re-designate which column(s) you are searching or the tool now
drops your column choice and searches the entire sheet. Thank you Bennie
Nicolo

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


--

Dave Peterson


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com