Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
samuel
 
Posts: n/a
Default Search should highlight entire row in Excell in red

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Samuel

If you think you have the ear of an Excel developer, think again.

Just us people like yourself here.

To possibly have this feature added to the next version of Excel.........

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:33:01 -0800, samuel
wrote:

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.


  #4   Report Post  
samuel
 
Posts: n/a
Default

I am not sure how to write a macro, I thought this was a suggestions place.

"Gord Dibben" wrote:

Samuel

If you think you have the ear of an Excel developer, think again.

Just us people like yourself here.

To possibly have this feature added to the next version of Excel.........

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:33:01 -0800, samuel
wrote:

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.



  #5   Report Post  
Ken Macksey
 
Posts: n/a
Default

Hi

I have a sample worksheet that will get you started. Email me and I will
send it to you.

HTH

Ken




  #6   Report Post  
Gord Dibben
 
Posts: n/a
Default

Samuel

I have not seen a question in your post(s).

I assumed you were only making a suggestion on how to improve the Find
feature.

Gord

On Mon, 27 Dec 2004 13:43:06 -0800, samuel
wrote:

I am not sure how to write a macro, I thought this was a suggestions place.

"Gord Dibben" wrote:

Samuel

If you think you have the ear of an Excel developer, think again.

Just us people like yourself here.

To possibly have this feature added to the next version of Excel.........

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:33:01 -0800, samuel
wrote:

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 - How to create an auto search echo7 Excel Discussion (Misc queries) 1 December 17th 04 05:32 PM
print entire workbook default KatGat01 Excel Discussion (Misc queries) 3 December 14th 04 11:12 PM
Search for a Sheet Chance224 Excel Discussion (Misc queries) 3 December 14th 04 01:29 AM
How to change an entire row using conditional formating John Edwards Excel Discussion (Misc queries) 2 December 9th 04 06:41 PM
EXCELL 2002 Glitch???? Gabriel20783 Excel Discussion (Misc queries) 1 November 29th 04 09:55 PM


All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"