How to automatically delete certain rows in Excel?
Let’s learn how to automatically delete certain rows in Excel. The most accurate or helpful solution is served by Super User.
There are ten answers to this question.
Best solution
I'm looking to automatically delete rows in Excel 2007 based on whether or not there is a cell with a specific value in that row. I've Googled around, but I've only found old information on VBA scripts for previous versions of Excel and so far all of it is non-functional. I'm looking for a SuperUser quality explanation on how to do this.
Answer:
This macro will delete rows that contain cells with the "fri" value, and then shift the cells...
hisnameisjimmy at Super User Mark as irrelevant Undo
Other solutions
For work, I am currently filtering through a long list of items, and I have been filtering them out by CTRL+F finding and replacing the keywords that indicate rows I don't want with a big XXXXXXXXXXXXXX, then going through and deleting those rows. But...
Answer:
You can try running a macro. 1. Press Alt+F11 to open the visual basic editor 2. On the left side of...
wing2871... at Yahoo! Answers Mark as irrelevant Undo
I have an Excel file (which I did not create) which has columns A-H and rows 1-1083. I cannot click outside this range of rows and columns because it is grayed out and unclickable. I can add or delete columns but I can only add rows, every time increasing...
Nahum at Yahoo! Answers Mark as irrelevant Undo
I have an excel sheet that has 11 columns with rows until 2500. I am wanting to create a macro that will either automatically delete or a macro I can create a button to initiate that will delete every row that has a 0 in columns H (Inv), I (Sales) and...
Answer:
Here's an easy macro to do it. It works for VLOOKUP. Check the variables at the top to make sure it...
Kevin Chang at Quora Mark as irrelevant Undo
I am trying to create a macro in ms Excel that will search all rows for the word "First" and remove those rows moving while also bumping all remaining rows up in the spreadsheet. However, I do not want this macro to affect Row # 1 which serves...
Answer:
You should do it something like below. The trick is to use a Step when you loop and to set the Step...
Josh at Yahoo! Answers Mark as irrelevant Undo
How do i delete specific rows using columns. I am trying to delete rows that have matching words in them but in different columns...Its so hard to explain. For example I am dealing ...show more
Answer:
Use VLOOKUP to identify the matching addresses Then Filter on the matches which VLOOKUP id's and delete...
IXHQMFWV6U2EHSSBL3C5YNTGCY at Yahoo! Answers Mark as irrelevant Undo
I need a macro for this I need to delete rows by comparing specific columns that have the number 0 suppose i want column a,b,AA, and AE if all those columns have the number 0 ...show more
Answer:
try click the very first letter on the left of the row and then clicking delelte and for the column...
IPE4WCRTHA4GRCRFE53DH5ERCM at Yahoo! Answers Mark as irrelevant Undo
I names in the spreadsheet in column A and Yes or No in column B. I want to make a function that if Yes in B1 then delete row 1. I am very new to excel so I really don't yet understand really complex excel stuff.
Answer:
For future Questions, please state the version and update level of MS-Excel that you use, it makes a...
Morgan at Yahoo! Answers Mark as irrelevant Undo
Answer:
Sort your spreadsheet by any column that contains data which is non-existent in the rows you want to...
Ravichandran at Answerbag.com Mark as irrelevant Undo
I have a spreadsheet with a what seems like a million hyperlinks that I need to delete, in column B is the Part Number that the hyperlink is based off of, in colun D, and one row down is the hyperlink. Some I need all the hyperlinks and rows deleted...
Answer:
If the only data in the rows containing the hyperlinks is in a certain column, you could try filtering...
Shannon T at Yahoo! Answers Mark as irrelevant Undo
Related Q & A:
- How to convert Json to CSV or Excel?Best solution by Stack Overflow
- How to allow only certain files in Apache?Best solution by Server Fault
- How do I group different rows in a field?Best solution by Stack Overflow
- How did people know certain things were safe to eat?Best solution by Yahoo! Answers
- Does Facebook automatically delete friends?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.