Software

Ask Software Development Questions and Get Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I need help with instructions on how to enter a command in…

Hi, I need help with...
Hi, I need help with instructions on how to enter a command in excel to search all rows that contain any of 8 words and highlight the row or remove the row. Is that possible? thanks
Show More
Show Less
Ask Your Own Software Question
Answered in 4 minutes by:
11/17/2017
Specialist Sean S.
Specialist Sean S., Computer Support Specialist
Category: Software
Satisfied Customers: 1,372
Experience: 5+ years IT experience. A+, Net+, Security+ certified
Verified

Good afternoon/evening!...My name is ***** ***** I look forward to helping you. Is there anything else to know other than remove any 8 specific words?

Ask Your Own Software Question
Customer reply replied 8 months ago
I actually need it to highlight or remove the entire row if any of the rows have any one of eight words

Okay. Do you want me to find a general command or do you want to give me those words and I can help construct the command. I would usually go about this by sorting the Excel document if any of those words meet the criteria and then highlighting them and deleting them. What are your thoughts?

Ask Your Own Software Question
Customer reply replied 8 months ago
Sure, actually just sorting them by the words would be better. Then I can cut and paste them to a different sheet. Then I would just need help sorting back. It is a list of people with the person's registration number, First, Middle Intl, Last, the year they were admitted to law school, The law school they went to, and then living or deceased. I would like to separate the 8 Ivy League schools - Brown, Columbia, Cornell, Dartmouth, Harvard, the University of Pennsylvania, Princeton, and Yale
Customer reply replied 8 months ago
I would like to separate all rows that contain any of those schools. It is currently sorted by last name

Okay. You wouldn't want a command then. You'll want to highlight the entire workbook, then Conditional formatting, then Highlight Cell Rules, then Text that Contains, then enter those words, and all the matches will be highlighted. Then you can sort them based on that matching color as well and copy, cut, etc.

Ask Your Own Software Question

Does that make sense?

Ask Your Own Software Question
Customer reply replied 8 months ago
Do you mind if I ask a few more questions though? It's been a very long time since I have used excel..
Customer reply replied 8 months ago
for example I don't even know how to "select all"

Sure. Also too, if you find it appropriate to help you, we have a remote connection option where I can show you these things too if it makes it easier, but feel free to use this chat as long as you'd like

Ask Your Own Software Question
Customer reply replied 8 months ago
I saw that but it is confidential info so I wouldn't be able to.

No problem. I completely understand. So you basically want to highlight the entire workbook or cells that have text in it. That is "select all"

Ask Your Own Software Question
Customer reply replied 8 months ago
For text that contains - do I have to do it seperately for each word? It stops selecting after I put a second word in. I tried separating by space and by comma

No, Once you select all the words/rows, then on the HOME tab, you should see CONDITIONAL FORMATTING on the middle of the ribbon. Do you see that?

Ask Your Own Software Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Software
Satisfied Customers: 2,205
Experience: 20 years experience providing remote computer support
Verified

HI i was working with you on this question, will be helping you from here

Ask Your Own Software Question

not sure why but for some reason you closed the other question, and I was unable to respond

Ask Your Own Software Question

can you send an example sheet, you can just make up a bunch of fake data to show what you want to accomplish

Ask Your Own Software Question
Customer reply replied 8 months ago
wow, that's annoying. I was in the middle of following the instructions that the other tech was giving me and was almost done. The other question was closed because I sat for close to an hour waiting for a response after you said "one Momemt"

Hi, I'm still here. I apologize about that. I will look into it to ensure it gets addressed. Would you like to continue working with me on this? Also, please note that negative rating will go to me and not the expert that joined that chat a few moments ago

Ask Your Own Software Question
Customer reply replied 8 months ago
Yeah, if we could finish that would be great. The other guy accepted my question originally and then didn't respond, that's what the negative was for. If you know how I can fix it, I will definitely do it.

Sure. i'm here now and will be happy to continue. I apologize for any inconvenience

Ask Your Own Software Question

Once we're done, if you can re-rate the question, that would negate the negative rating on this one which will affect me and not the other expert. Where did we leave off at?

Ask Your Own Software Question
Customer reply replied 8 months ago
ok sure. I am doing the conditional formating and entering the "text that contains", with each word seperately. Doesn't seem to work otherwise. And the file has some of the colleges listed or abreviated differently so Im getting them all added

Okay. Are you able to see where CONDITIONAL FORMATTING is on the HOME tab in the middle of the ribbon?

Ask Your Own Software Question
Customer reply replied 8 months ago
I have gone there and then I selected Highlight Cell Rules, then Text that contains, and I have all of the cells with those words highlighted now. Would I sort the rows now?

Yes. We're at that step now. Great! What's the next thing you need from me for this?

Specialist Sean S.
Specialist Sean S., Computer Support Specialist
Category: Software
Satisfied Customers: 1,372
Experience: 5+ years IT experience. A+, Net+, Security+ certified
Verified
Specialist Sean S. and 87 other Software Specialists are ready to help you
Ask your own question now
Customer reply replied 8 months ago
How do I sort the rows with the highlighted cells?
Customer reply replied 8 months ago
I actually just figured it out. Thank you very much for your help. I appreciate it.

You're very welcome. If you would like to request me directly anytime in the future, here the link to do so. I'll get an e-mail if I'm off-line https://www.justanswer.com/computer/expert-ssaunders/?rpt=3800

Ask Your Own Software Question

Were you able to re-rate the question as well to avoid the negative rating from counting for me?

Ask Your Own Software Question
Customer reply replied 8 months ago
I rated 5 starts. If I need to contact support to fix the first one, please let me know

Will do. Thank you. have a great day!

Ask Your Own Software Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a software technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Specialist Sean S. Your Own Question
Specialist Sean S.
Specialist Sean S.
Specialist Sean S., Computer Support Specialist
Category: Software
Satisfied Customers: 1,372
1,372 Satisfied Customers
Experience: 5+ years IT experience. A+, Net+, Security+ certified

Specialist Sean S. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

745 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

526 satisfied customers

Certified Software expert with over 10 years experience.

Jins M. N.

Jins M. N.

Computer Hardware Engineer

517 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

514 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

511 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

187 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I hope ypu remember me and the project we worked on I need
Hi I hope ypu remember me and the project we worked on I need you to add 3 more rows below line 39 and copy the macros from the above lines so that the function works also on those new rows, I will at… read more
The-PC-Guy
The-PC-Guy
Software Engineer
2,205 satisfied customers
I need to format a doc in Word so that text typed on one
I need to format a doc in Word so that text typed on one side of the page is duplicated on the other. I've tried using two columns, mirrored images, and pasting. Nothing works. What I am trying to do … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,130 satisfied customers
Can someone can tell me the conditional formatting formula
Can someone can tell me the conditional formatting formula in Google Sheets to highlight a row if it contains any occurrences of key words (from a list)?… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Running Excel 2010. Have a spreadsheet designed as an index
Running Excel 2010. Have a spreadsheet designed as an index for a genealogy I have written in HTML. Column B contains names. Column A contains the HTML page name where the col A name is ***** ***** a … read more
Kris R
Kris R
IT Manager
Computing
3,312 satisfied customers
I have an excel question. I have stock in column F. I want
I have an excel question. I have stock in column F. I want to highlight in columns C, D, and E that do not contain stock. I can upload the file, but I would like to be shown how to do this.… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
745 satisfied customers
Microsoft Excel Required:- an Excel "Expert" - a person with
Microsoft ExcelRequired:- an Excel "Expert" - a person with "advanced" Excels Skills and Practical Experience.Please do not apply unless you are certain that you understand the question and that you c… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
Excel In a spread sheet of multiple columns, I want some
Excel In a spread sheet of multiple columns, I want some rows to run across (headings). Right now, they don't even wrap in the cell.… read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
789 satisfied customers
I am working with google sheets which numerous sales people
I am working with google sheets which numerous sales people enter minimal data into each day and I need some assistance. I know it is not in the league of Excel however the dealership uses google thro… read more
George Sibiya
George Sibiya
PhD
309 satisfied customers
If I want once cell to erase over a 100 cells by clicking
If I want once cell to erase over a 100 cells by clicking that one cell or entering a command Is that at all possible?… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
My adobe has stopped working. I can receive pdf files but
My adobe has stopped working. I can receive pdf files but cannot open them. I am currently using Adobe Acrobat XI Pro. How can I get some help?… read more
Mr.Med
Mr.Med
1,184 satisfied customers
I previously had PSE 8 with photos downloaded. Yesterday,
I previously had PSE 8 with photos downloaded. Yesterday, I installed PSE 11. In the process of bringing the photos into PSE 11, something happened. Photos on the organizer of both 8 & 11 now contain … read more
Jins M. N.
Jins M. N.
Computer Hardware Engineer
Diplom
517 satisfied customers
This is about Excel csv sheets. I have filtered a csv sheet
This is about Excel csv sheets. I have filtered a csv sheet for duplicates. They are showing up in a column in red. 1) Does this number of duplicates represent the files including the duplicates? (So … read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
I seem to have 7 days free to ask questions. Can I start now
I seem to have 7 days free to ask questions. Can I start now re installation of Windows 8.1 update?… read more
Andy
Andy
Design Engineer
MS Electrical Engineering
8 satisfied customers
I HAVE INTERNET EXPLORER 8 PROVIDED BY YAHOO and want to uninstall
I HAVE INTERNET EXPLORER 8 PROVIDED BY YAHOO and want to uninstall it and get the regular IE9 provideded by Windows… read more
IT Miro
IT Miro
Computer Scientist
Bachelor's Degree
511 satisfied customers
HI THEREI am running Windows 7 and have just installed Office
HI THERE I am running Windows 7 and have just installed Office Home & Business CD. It appears to have loaded properly but when I tryl to access my document files (both word and excel) i get the docume… read more
Austin Atkins
Austin Atkins
Masters student - Physics
Bachelor\u0027s Degree
394 satisfied customers
Hello, Is if possible to have Adobe search a document and
Hello, Is if possible to have Adobe search a document and automatically locate and highlight the specified word? Thanks JOHN XXX-XXX-XXXX… read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
526 satisfied customers
I use Chrome and Google as search machine. But Yahoo keeps
I use Chrome and Google as search machine. But Yahoo keeps taking over and places itself at the search machine in Chrome. This is extremely annoying! I have to change it back manually every time. Does… read more
Josh
Josh
It Support Specialist
Associate Degree
5,150 satisfied customers
HELP! Ive been using my Dragon for about a week now, and suddenl
HELP! I've been using my Dragon for about a week now, and suddenly it is repeating every word I dictate twice! How can I make it only type what I say once? I have a tech paper to write and am on a dea… read more
Douglas
Douglas
SEM Specialist
163 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x