Jump to content

MS WORD2013/Excel2013. a giant table, how to search and find all cells containing the same text?

HeyKitty
By HeyKitty
in Programs, Apps and Websites
 Share
Go to solution Solved by Master Disaster,

Select the range of cells you wish to test.

On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.

Click OK within the Duplicate Values dialog box to identify the duplicate values.

Duplicate values in the list will now be identified.

That should highlight all cells containing duplicate values

Posted

So I got a big ole table, I have it in a Word doc and Excel sheet. each box just has anywhere from 1 word, to 2 sentences.

 

All I want to do is it to select all the boxes so I can easily spot them.  Unless there is a way for it to go ahead and just delete it and shift all the cells for me.

THIS IS MY SUPER TEENY TINY SIGNATURE!

Ain't it just the cutest little signature.

Some would argue it is the cutest little signature ever.

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

CTRL-F?

 

Spoiler

i5 4670k, GTX 970, 12GB 1600, 120GB SSD, 240GB SDD, 1TB HDD, CM Storm Quickfire TK, G502, VG248QE, ATH M40x, Fractal R4

Spoiler

i5 4278U, Intel Iris Graphics, 8GB 1600, 128GB SSD, 2560x1600 IPS display, Mid-2014 Model

Spoiler

All the parts are here, just need to get customized cords to connect the motherboard to the front panel.

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

crtl+F

~New~  BoomBerryPi project !  ~New~


new build log : http://linustechtips.com/main/topic/533392-build-log-the-scrap-simulator-x/?p=7078757 (5 screen flight sim for 620$ CAD)LTT Web Challenge is back ! go here  :  http://linustechtips.com/main/topic/448184-ltt-web-challenge-3-v21/#entry601004

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author

Yeah, I know how to find, but I want it to find any two cells that have the same text. I can't sit here and sift through the 8K cells....

THIS IS MY SUPER TEENY TINY SIGNATURE!

Ain't it just the cutest little signature.

Some would argue it is the cutest little signature ever.

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Solution

Select the range of cells you wish to test.

On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.

Click OK within the Duplicate Values dialog box to identify the duplicate values.

Duplicate values in the list will now be identified.

That should highlight all cells containing duplicate values

Main Rig:-

Ryzen 7 3800X | Asus ROG Strix X570-F Gaming | 16GB Team Group Dark Pro 3600Mhz | Corsair MP600 1TB PCIe Gen 4 | Sapphire 5700 XT Pulse | Corsair H115i Platinum | WD Black 1TB | WD Green 4TB | EVGA SuperNOVA G3 650W | Asus TUF GT501 | Samsung C27HG70 1440p 144hz HDR FreeSync 2 | Ubuntu 20.04.2 LTS |

 

Server:-

Intel NUC running Server 2019 + Synology DSM218+ with 2 x 4TB Toshiba NAS Ready HDDs (RAID0)

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author

Select the range of cells you wish to test.

On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.

Click OK within the Duplicate Values dialog box to identify the duplicate values.

Duplicate values in the list will now be identified.

That should highlight all cells containing duplicate values

*HUGS* This works great! thanks for the help!

THIS IS MY SUPER TEENY TINY SIGNATURE!

Ain't it just the cutest little signature.

Some would argue it is the cutest little signature ever.

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×