How to select/copy all cells containing a specific keyword...

C

Cubicle_53

New Member
Joined
Feb 15, 2010
Messages
5
Hi,

Is there an easy way to automatically select all the cells in a worksheet that contain a specific word?

I want to be able to select all of them and then move all of them in one shot.

Conditional formatting highlights the cells but I can't figure out how to select only those highlighted cells.

Thanks.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Use find and select and in find what use *whatever you are looking for * and click find all. It will bring up a scroll bar for each find. Select all with mouse and on one in the spreadsheet, right click and copy and paste. The same would be with cut and paste...
 
Upvote 0
I figured it out.

I just set up a filter to show only the cells containing a specific text string.

Yeah!

Never used filters before - will use them from now on.
 
Upvote 0
You must log in or register to reply here.

Similar threads

dcofer
  • Solved
Locating Words With Specific Letters in a Column
Replies
5
Views
158
dcofer
dcofer
A
  • Question
VBA Highlight cell if contains specific text
Replies
4
Views
156
DanteAmor
DanteAmor
K
  • Question
stubborn cells REFUSE to calculate as a formula even when calculate is set to automatic...(?)
Replies
2
Views
85
Alex Blakenburg
A
M
  • Solved
The TOP 1 item in a row Conditional Format seems broken to me
Replies
5
Views
242
Mr_Phil
M
P
  • Solved
format text in multiple cells
Replies
2
Views
250
paulyankson
P

Forum statistics

Threads
1,215,059
Messages
6,122,913
Members
449,093
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top