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

How to automatically delete rows in Excel 2007 based on cell value?

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...

Read more

hisnameisjimmy at Super User Mark as irrelevant Undo

Other solutions

How can I delete entire rows in Excel that contain certain keywords?

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...

Read more

wing2871... at Yahoo! Answers Mark as irrelevant Undo

How to delete rows in Excel 2003?

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...

Answer:

"… which has columns A-H and rows 1-1083." "… grayed out and unclickable...

Read more

Nahum at Yahoo! Answers Mark as irrelevant Undo

Excel Macros: How do I delete Rows based on value in three columns?

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...

Read more

Kevin Chang at Quora Mark as irrelevant Undo

Creating a Microsoft Excel Macro to Delete Rows That Contain a Certain Word.?

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...

Read more

Josh at Yahoo! Answers Mark as irrelevant Undo

Question about Excel and how to delete multiple rows with matching words?

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...

Read more

IXHQMFWV6U2EHSSBL3C5YNTGCY at Yahoo! Answers Mark as irrelevant Undo

Delete rows containing a certain number in specified columns in excel?

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...

Read more

IPE4WCRTHA4GRCRFE53DH5ERCM at Yahoo! Answers Mark as irrelevant Undo

How to delete rows using excel function?

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...

Read more

Morgan at Yahoo! Answers Mark as irrelevant Undo

Excel macro to delete all rows containing hyperlinks?

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...

Read more

Shannon T at Yahoo! Answers Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

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.