ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when I search for data in Excel, the found cell cannot be seen (https://www.excelbanter.com/excel-discussion-misc-queries/100562-when-i-search-data-excel-found-cell-cannot-seen.html)

Howard in GR

when I search for data in Excel, the found cell cannot be seen
 
The FOUND cell is barely identifiable from the other cells, so I cannot see
what cell is being found. Can I change this somehow so that the found cell is
very identifiable ?

Dennis

when I search for data in Excel, the found cell cannot be seen
 
Check to see if either that cell and/or the respective Row/Column is
hidden. If so,
"Paint the area around the cell" (select) then Format|Row|Unhide and/or
Format|Column|Unhide

HTH Dennis


Howard in GR wrote:
The FOUND cell is barely identifiable from the other cells, so I cannot see
what cell is being found. Can I change this somehow so that the found cell is
very identifiable ?



starguy

when I search for data in Excel, the found cell cannot be seen
 

when you search for any cell, after search result is displayed, it is
difficult to see the FOUND cell specially when all cells on sheet have
data.
you should look at your right side, row number will be highlighted of
cell FOUND then see for highlighted column. At the intersection of
highlighted row number and column you will find your searched cell.

Howard in GR Wrote:
The FOUND cell is barely identifiable from the other cells, so I cannot
see
what cell is being found. Can I change this somehow so that the found
cell is
very identifiable ?



--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563690


Gord Dibben

when I search for data in Excel, the found cell cannot be seen
 
Howard

You should be able to see which cell has been selected just by looking in the
Found dialog box.


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 06:33:01 -0700, Howard in GR <Howard in
wrote:

The FOUND cell is barely identifiable from the other cells, so I cannot see
what cell is being found. Can I change this somehow so that the found cell is
very identifiable ?




All times are GMT +1. The time now is 02:36 AM.

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