Microsoft Office
Microsoft Office questions? Ask an IT Expert for support ASAP
Connect one-on-one with {0} who will answer your question
Answered in 1 minute by:
1/14/2022
Category: Microsoft Office
Satisfied Customers: 2,582
Experience: Owner at EZ MM Software, LLC
VerifiedHello, and thank you for reaching out to Just Answer a third-party PAID question and answer forum staffed by various experts in our fields, my name is Michael. I have been an IT and Telephony, and electronics expert for over thirty-seven years.
I am versed in hardware and software for various computer systems, tablets, laptops, and mobile devices.
I know how frustrating it can be when it comes to dealing with technology. I try to speak computer to the computer and English to my customers. Due to COVID19 and a lack of support personnel, many companies have limited or eliminated their support phone or online support.
Please give me just a moment to review the notes, and I will be right with you. In the meantime, feel free to add any additional pertinent information to your ticket that I might need to consider before rendering potential solutions.
Thank you for the honor of serving you today.
** NOTE: If at any time you want to stop chatting and start a remote session, just say “Remote Me”.
I am so sorry you're having issues with Excel today. I will do my best to expedite a resolution to the issue or locate a resolution that can be for you. OK?
How To Delete Blank Cells in Excel using Go To Special
- Select cell range. Highlight all the cells you want to filter.
- Select Go To Special from the Find & Select menu. You'll find the Find & Select Menu on the Home tab in the Editing group. ...
- Select the Blanks option in the popup menu. ...
- Delete selection.
How JustAnswer works
Describe your issueThe assistant will guide you
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
100% satisfaction guaranteeGet all the answers you need
Related Microsoft Office Questions
Google sheets, need help merging 2 spreadsheets with a
Google sheets, need help merging 2 spreadsheets with a common ID to match them but I don't know how to do it in google sheets https://www.ablebits.com/office-addins-blog/excel-merge-tables-matching-co… read more
Mian-Wisal Ahmad
Field Engineer
MS Electrical Engineering
2,345 satisfied customers
I have a spreadsheet that I want to remove some of the data
I have a spreadsheet that I want to remove some of the data that was entered in each cell. Is there a way to do that globally or do I have to go cell by cell? … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I need a formula / macro to insert a row of data in between
Hi, I need a formula / macro to insert a row of data in between other data. The s/s is an export of over 1000 products from a website and I need to insert a new price/size option for every product. … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
How do I do the following: look at A column on sheet 1 and
How do I do the following: look at A column on sheet 1 and if "LC" then copy row to Sheet 2 … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
MS Excel question. Attached excel spread sheet example.1st
MS Excel question. Attached excel spread sheet example.1st columns, how do you separate first and last name and put them in two separate cells all at once? B columns, there are some blank cells, how d… read more
Bob
Masters
2,365 satisfied customers
Here is my inquiry: I have a spreadsheet in front of me that
Here is my inquiry: I have a spreadsheet in front of me that has dates across the top (X axis) Jan 1, 2, 3, 4... etc and then names on the side (y axis). Each data cell is populated with either 0 or 1. I would like to automate the spreadsheet so that it highlights any value that shows more than 25 consecutive "1's" for each person. Can you help please? … read more
Jess
Bachelor's Degree
2,637 satisfied customers
All of my Excel spreadsheets have been rotated 180 degrees
All of my Excel spreadsheets have been rotated 180 degrees in vertical and horizontal. how do I return them to normal? … read more
Michelle
Manager operations
Bachelor's Degree
3,336 satisfied customers
In furtherance of our conversations on Tuesday. I have
In furtherance of our conversations on Tuesday. I have another question. Can I split a row in Excel?… read more
Stuart Woods
IT Technician.
Bachelor in Information Technology
48 satisfied customers
I have two excel files. Both are having same number of
I have two excel files. Both are having same number of sheets. Each sheets are having same types of data. I want to compare both excel files sheets by sheets. E.g. Sheet 1 of File 1 with Sheet 1 of Fi… read more
Bing
Freelance IT Consultant
2,524 satisfied customers
I have an excel question. I have a database download
I have an excel question.I have a database download worksheet with data sorted in columns. The first column is the all model numbers with multiple part descriptions for each model (i.e. 30-40 parts wi… read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I require an expert "excel" person to assist me design a
I require an expert "excel" person to assist me design a step by step process for processing a large quantity of data in an efficient and timely manner and I am attaching my question by way of a word … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I am using excel 2016 and have a column of numbers that are
I am using excel 2016 and have a column of numbers that are formatted as general after 4,000 rows I come across a cell that is still formatted as general yet has that little yellow indicator that the … read more
Pete
4,068 satisfied customers
Comparing 2 identically formated worksheets to find
Comparing 2 identically formated worksheets to find differences and produce values? I would like SHEET1 A4 to produce the following values: (to be copied to 50,000+ rows) "NEW ITEM" - IF ACCT# : B4 an… read more
Jess
Bachelor's Degree
2,637 satisfied customers
I am trying to have cells on one worksheet, arranged in a
i am trying to have cells on one worksheet, arranged in a duplicated pattern, reference cells on a worksheet in the same workbook. the sheet containing the data is arranged by row, the sheet containin… read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I need someone to create a VBA macro in excel to merge the
I need someone to create a VBA macro in excel to merge the following: Cell A6: Cell A7, Cell B6: Cell B7, Cell C6: Cell C7, etc.... I need to maintain the formatting of the bold headings in row 6. I n… read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
Dea SirsI have an Excel 2003 workbook.My question is
Dea Sirs I have an Excel 2003 workbook. My question is how to autonumber rows when rows filled with text and blank rows, there are between the rows that i want autonumber. Below, i give an example: 1 … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
ExcelI have a sample spread sheet which has three vendors
Excel I have a sample spread sheet which has three vendors with 3 different prices for a part. I would like a formula that will pick out the vendor with the lowest cost and put the corresponding infor… read more
Zabo04
Computer Enthusiast
Master's Degree
73 satisfied customers
Im using Excel to print 270 name badges. I have each name
I'm using Excel to print 270 name badges. I have each name in column A. The print template in Word is setup with 6 name badges on a sheet (2 wide, 3 tall). Once fully printed I will have 45 pages with… read more
Robert M.
Bachelor's Degree
4,290 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.
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.
...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.
New York
Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.
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!!!!
Los 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.
Hesperia, CA
I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.
Kernersville, 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.
Woodstock, 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.
Elkton, Maryland
< Previous | Next >
Meet the Experts:
The-PC-Guy
Computer Manager
877 satisfied customers
20 years experience providing remote computer support
Shefin
Microsoft Office Specialist
701 satisfied customers
Working as Tech support specialist with a world famous computer manufacturer
Miro
Computer Support Specialist
229 satisfied customers
Bachelor's Degree in Information Technology, Microsoft Certified Professional
Steve Herrod
Computer Support Specialist
132 satisfied customers
Trained in Microsoft Office from 2000 through to latest version 2010.
Zabo04
Computer Enthusiast
73 satisfied customers
Experienced in Word, Excel, Access, Powerpoint, and Outlook.
Travis
Computer Enthusiast
32 satisfied customers
I have 12 years of experience in the IT field.
Val B
Analyst / Trainer
31 satisfied customers
Expert in solving Microsoft Office problems.
< Previous | Next >
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.
