Monica, thanks for the very kind words!

I'm glad you found it useful

Glad you found it useful!

I'm glad it was useful for you.

Thanks! I'm glad it was useful for you.

Glad to hear you found this useful

Thanks, glad you found it useful.

I'm glad you liked it!

I'm glad you found it useful!

I'm glad you found this useful!

Great to hear that you found this useful.

I'm glad you liked it!

Thanks!

Thanks, I'm glad you found it useful.

Glad you liked it!

Glad you liked it.

I'm glad to hear that!

Thanks, glad you liked it.

Thanks. Glad you liked it!

Glad to hear it!

Thanks! I'm glad it was useful for you.

You're welcome, glad you liked it!

You're welcome!

Thanks!

Can you give me an idea of how your data is structured? Send an image or a copy of the file to mrempel@excel-bytes.com

Thank you. I'm glad you liked it.

Thanks. Glad you liked it

I'm glad you found this useful!

You're welcome, glad you liked it.

Thanks, glad you liked it.

Glad you liked it!

I'm not sure I understand your scenario. Can you send a sample file with an example to mrempel@excel-bytes.com and I will take a look at it.

Glad you liked it!

Glad you liked it.

I'm glad you found this useful!

Not all that familiar with Excel for Mac, but here might be an option: Turn on filters and filter the rows by whatever criteria. Select the filtered range. Choose visible cells only (in windows this is a keyboard shortcut Alt plus semicolon, in windows you can also hit the F5 function key, click on Special, then select "visible cells only" and hit OK ) . Now delete those rows and you should be left with everything else. I would test this on some sample data first to make sure you don't delete any original data that you didn't want to.

I'm glad it was helpful.

Follow these steps (save your work first, in case you make a mistake you can reopen it without saving the changes): 1) activate filters 2) filter the data based on the column of values for items greater than 8 3) highlight that filtered column 4) hit the keyboard shortcut Alt + ; (hold down the Alt key and press the semi colon key) 5) hit the keyboard shortcut Ctrl - (hold down the Ctrl key and press the minus sign on the keypad) 6) a message should pop up to delete entire row - select OK 7) remove filters - your rows with values greater than 8 should be deleted

@@ExcelBytes perfect! Thank you very much. You earned a new subscriber! I am an engineer and I will make sure to let others know about your channel.

@@kyguygaming6891 Thanks. Hope you enjoy my tutorials and find them useful.

I assume you want to keep the original and only delete the duplicates. It would be a multi step process. You can add a helper column and use the COUNTIF function to see where the duplicates are, the use the FIND option to choose those rows and delete them. If you want to send me a sample copy of your data and describe what you want to accomplish, I'd be happy to help. You can send it to mrempel@excel-bytes.com.

I'm sorry but I don't have access to Excel for Mac, so I'm not sure of the differences.

The concept should be the same. Do a Ctrl F, find "0", click on Find All. Is that not working for you? What happens when you do this?

Thanks. Glad your liked it.

You can with a couple steps. Add another column with a formula like =IF(OR(A2="Tom",A2="Mke"),"x",""), then convert those cells to their values. Now do the same process with Ctrl + F, find all, etc...

👍

I'm glad you found this useful.

It would be easier to see the data, but one option would be to use a helper column to the right of your data and insert an IF formula that would indicate Yes or No based on the criteria you mentioned, then use the rows with YES to determine which to delete.

Great! Glad it was helpful!

No problem, I hope you found this useful.

Not sure why you can't. If you want, we can do a quick call or video chat so I can see what the issue is and try to figure out what is happening. If you are interested in contacting me, send an e-mail to me at mrempel@excel-bytes.com and we can set something up from there.

I'm glad it was useful for you!

Mike, can you select rows with certain data and move it to another sheet?

@@Bicyclefarms The simplest way to do this is to activate filters, filter the data based on the column and criteria, once filtered, highlight the data, use the keyboard shortcut Alt + ;, this will highlight the visible cells only. Copy those to another sheet, then use the process from this video to delete the ones you just copied.

Glad you liked it!

Try these steps: Activate the filters. Uncheck Tom in the filter list, click OK. This should filter the list to everyone but Tom. Highlight the list of names and use the keyboard shortcut Alt + ; (the Alt key plus the semi-colon key). This will select all the visible cells. Use the keyboard shortcut Ctrl + - (hold down the Ctrl key and press the minus sign on the keypad). You should get a pop up that says "Delete entire row?". Click OK. Remove the filters and you should only have the rows with Tom left.

I'm not that familiar with Google Sheets, but I don't see a way to do a Find All. If you have all the cells selected manually, you can delete all the rows at once under the Edit > Delete commands

Depending on the details of your data, yes, there can be. One method would be to add a helper column, just another column on the right of your data, then use an IF formula to add a value like an "x" if the criteria is met. Then use the process described in this video to delete the rows with an "x". If that's not quite what you are looking for, feel free to send me a sample of your data with what you want to accomplish to mrempel@excel-bytes.com and I will take a look at it.

Elizabeth, can you provide me with an example of what you are trying to do? You can send it to mrempel@excel-bytes.com with an explanation and I will look at it for you.

There is no way for me to predict that without knowing if you have any formulas, named cells or ranges that reference the columns that you are going to delete.

Let me clarify. You have a worksheet with several columns, and it the first row, some of the cells have data and others do not, and you want to delete the entire columns where there is data in the first row? Are the other cells in the first row truly blank, or do they have formulas or other characters in them and only look blank?

@@ExcelBytes Much thanks for them response! I have a worksheet where the first row holds labels for the columns, First Name, Email, Etc. Some of these columns have data in the cells below, and some are empty beyond the label in the initial row. I’d like to remove the columns where there is only the label in the initial row and no other data.

@@christianmagill3829 OK, so every column has a header, but not all columns have data below the header, and you want to delete all the columns that have a header but have no data in row 2 for that column. If that is correct, here is what you do: select row 2 for all the columns, hit F5 on your keyboard, click on "Special", click blanks, click OK, use the keyboard shortcut Ctrl and the minus sign from your keypad, choose "Entire column", click OK. That should work. If it's not what you want, do a Ctrl + Z to undo it. This assumes that the items in now 2 that you want to delete are truly blank, and do not have formulas or other characters in them that just make those cells appear to be blank. Let me know what happens. Make sure you save your file first in case things go awry. If they do, you can always close the file without saving it and get back what you had before.

@@ExcelBytes Thanks for this! One clarification just to make sure it doesn't change the recommendation, there may be data in any row, not just row 2. Some columns might have data in say row 18 but no data in row 2. I'm just looking to remove columns that have nothing from row 2+

@@christianmagill3829 Well, that's a pretty significant clarification. If you have a lot of columns and also many rows so it's not easy to visually see what columns to delete, you many want to insert a row above the header, then enter this formula above the first column and copy it across: =IF(COUNTA(C3:C16)=0,"x",COUNTA(C3:C16)). Notice I started in row 3, assuming the formula will be in row 1 and the headers are in row 2. This shows data in only 16 rows, so you will need to adjust that based on the size of your data. Now when you copy that across you will see an "x" above any column where there is no data from row 3 down. Now if you hit F5, "Special", then choose Formulas, but uncheck everything but "text", now it will highlight only the cells with an "x". Then you can use the keyboard shortcut Ctrl and the minus sign from your keypad, choose "Entire column", click OK.

I'm sorry, but I'm not exactly sure what you are trying to do. Can you either explain more clearly, or you can send a sample of a file to me at mrempel@excel-bytes.com and I will take a look at it.

@@ExcelBytes I'm sorry for not explaining myself better before. In your example you use ctrl+f to find and highlight all columns that contain "Tom" before deleting them. Could you find and highlight columns with different headers using the same function? Say, if in addition to remove the "Tom" columns you also wanted delete the columns containing "Rick", could you ctrl+f "Tom, Rick" or would you have to do it iteratively (first delete Tom and then delete Rick)? Again, many thanks for your help!

@@BogardanHellkite Are you deleting rows or columns?

@@michaelrempel2905 columns. I have a massive table (12000 rows by 4000 columns). Each column has a different header. Then I have another table with the names of the columns that I need to filter out from the 1st dataset.

@@BogardanHellkite I don't know how to do what you want with Ctrl + F. I'm sure there is VBA code available to do this, but I don't know it well enough to write it. All I would know to do is, as you suggested, do it iteratively.

You can activate filters, filter the rows by color, choose visible cells only (shortcut Alt + ;), the delete the visible rows and that should work.

What do you mean "when you apply shortcuts"?

@@ExcelBytes control f especially. I can see all this in the libre office but not in sheets.

@@shreyasshreyas8037 Are you trying this in Google Sheets or Excel

@@ExcelBytes Google sheets.

@@shreyasshreyas8037 Sorry, I'm not familiar with Google sheets to know if this will work with it

Please explain to me what you mean by persistent.

If you want it to automatically delete rows when you type something on another worksheet, that would require VBA code, which I'm not well versed enough to assist you with. If you want to do it in a similar fashion to Example 1, when you bring up the Find dialog box, type in the word you want to find, click on options, and choose "Within Workbook", then follow the same procedure.

@@ExcelBytes thanks I'll try that

Are you saying deleting any rows or columns, or deleting any cells?

@@michaelrempel2905 either row or column

@@Vziera Using the example data from the tutorial, I would enter into N2 this formula: =A2="Tom", and copy it down. This will result in a series of TRUE or FALSE. Copy those and paste values only in the same range. Now you can do a Find All for "FALSE" and delete those rows.

A quick, simple way would be to add a helper column at the and and insert the formula =A2="Tom" and copy it down. You'll get a series of TRUE or FALSE. Convert those to values instead of formulas. Then use the same process to find FALSE and delete those rows.

It would be easier to reply if I saw what your data was like, but one simple way is to add a helper column, then in that column use one of the COUNT functions to determine if there is anything in that row. Then you can use those results to select the rows that are completely blank. If you want to send me a sample of your data, I can show you what I mean. You can send it to mrempel@excel-bytes.com

Thanks!

That depends. I'm not sure your specific situation. Are the items in column A alpha-numeric? Are you looking for a specific text string like "23Tom"? Are you looking for anything that starts with a "2" or anything that starts with any number? What exactly is your criteria? You need to be more specific.

@@ExcelBytes The data usually is dynamic. It sometimes is all numbers, sometimes mixed. But my specific requirement is to only delete the rows where column 'A' cell values starts with a number

6143 6160 6160 D6011167A D6011167A D6011167A D6012651A So in this only first 3 rows should be deleted since they are starting with numbers

@@ayushijain1242 I would use a helper column. So, assuming your data starts in cell A2, in some column in row 2 use this formula: =IF(ISNUMBER(LEFT(A2,1)*1),"Y","N") Now you can use the process in the video looking for a "Y" in that column and delete those rows.

I'm not an expert in Google sheets, and what I can see they don't have "find all". One thing you might want to try (do this on test data so you don't mess up your important information) is to add a column numbering all your rows. Then sort the data by the column that you want to use to delete the rows (in my example it would be column A with the names). After sorting, delete the rows that contain the selection you want to delete. Finally, resort by the number column you added to return the data to its original sorting - without the delete rows.

Not that I am aware of

Can you provide more details? For example, are you on a Mac or Windows? Are you using the "-" from above the keys, or from the keyboard to the right? What version of Excel are you using? Are you using a full keyboard or a laptop?

@@ExcelBytes I am using a Windows on an Intel Mac (Windows 10) And I am running excel's latest version I believe : Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit I tried using the ctrl + - on the top right of my horizontal number / signs panel

By panel I meant the number row on top in the top right I tried several times and FYI the manual delete option is greyed out when the col names are selected, only if I pick an entire column will it give me the option

Well interesting on an other spreadsheet it is working fine, maybe it is because I have a Pivot Table referring to my table array from where I wanna bulk delete the cols

Thanks

You're welcome, glad you liked it.

@@ExcelBytes I need your help! Eversince installing a new microsoft package, my delete option fades away when I want to delete multiple selected columns. I have really tried everything, even ctr - does not bring up anything

@@moiragreyling9561 What version of Excel? Microsoft 365? I haven't heard of this one. See these message strings and see if any of these suggestions help: answers.microsoft.com/en-us/msoffice/forum/all/excel-365-cannot-select-a-row-or-column-for-delete/d39fc46f-cb6e-44e6-8baa-1362da265832 social.technet.microsoft.com/Forums/ie/en-US/1d231b9d-71aa-4570-94e1-a0ce97298a0c/quotdeletequot-in-the-excel-rightclick-menu-is-grayed-out?forum=excel answers.microsoft.com/en-us/msoffice/forum/all/cannot-delete-rows-in-excel/0b59aab3-5caf-4d52-9a3b-24ab9e981355

@@ExcelBytes yes its 365. So when I use the find function, I find all the columns with something specific. Then the list is indicated in the find block, then I select all and want to delete those columns - this is when the delete function fades out and I can't use it

@@moiragreyling9561 I can't replicate the issue and haven't found anything on other forums that help. In the link I sent to you there was a suggestion in the replies to run a simple VBA code and it seemed to help. The code is: Sub Test() Dim Item For Each Item In Array("Cell", "Row", "Column", "Ply") CommandBars(Item).Reset Next End Sub Are you comfortable with trying this? Do you need assistance walking you through how to do this?