Home

OUTLINE THE CELL YOU'RE SEARCHING FOR

AintQuiteRite
New Contributor

   When I'm in a database and need to find a certain cell, is there a way to make that cell easy to see when Excel finds it?  As it stands now, you have to roam the screen to find the "found" cell.

3 Replies
This may work Right-click on your sheet's tab and View Code. Paste in the following: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Borders(xlInsideVertical).LineStyle = xlNone Cells.Borders(xlInsideHorizontal).LineStyle = xlNone ActiveCell.BorderAround ColorIndex:=3, Weight:=xlThick End Sub (found on another site)
Tanya, thanks for replying to me. I'm not sure where this is to be pasted. A little further help would be greatly appreciated. I use the FIND tool in Excel nearly all day at work. It can drive you nuts finding where it "lit".
Hi, please see attached for steps to take. Someone may have a better idea.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies