Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there someway to select what i have "found"?
hello,
is there a way to select multiple cells based on the text contained within them? i can use "find" to find what i am looking for, but i can not seem to select all of these cells. i have taken a crash course in naming, formulas, go to.., filtering and anything else i can try, but nothing seems to work. or it could just be my brain. Alternately, is there a way to easily reorganize one huge long column into multiple columns while maintaining the coherence of the data groups. IE the long column contains sets of text in several cells like a1 through a6, then the next set is a8 through a12, etc. But i need to have these groups in columns next to each other. i am just learning about macros and such, so i do not know if i can accomplish anything to advanced. do not know if i am making sense with this as i am fairly loopy right now. any help would be appreciated. thnx |
#2
|
|||
|
|||
Hi 1stpope,
Try this... If you do a find and click on "Find All", you should see the dialog expand to show a list of the cells. The first of these will be highlighted. Scroll down to the end of the list, hold down the Shift key, and click the last cell listed. You should now see that all your "found" cells have been selected. At this point you can close the dialog and dow what you need to do. As for the column reformatting, that would take some VBA and some understanding of what defines your groups. It might be complex... Regards, Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to select the first blank cell in column A | Excel Worksheet Functions | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Select all data, multiple rows | Excel Discussion (Misc queries) |