I have Excel for Mac, 2011 I have a large spreadsheet and need to remove all rows that contain a specific text in one of the columns. For example, it could be a bank statement with thousands of rows and I want to remove all non-deductables from it, so I search for all the rows that contain, say 'Amazon' and delete them. Then all the rows that contain 'Curry Shop' and delete them. Under the windows version I can use 'Find & Select' on the home ribbon to find all rows containing specific text and the use 'delete sheet rows' from the home ribbon to delete them all.
How can I do the same thing in the Mac version? Thanks in advance!
![All All](/uploads/1/2/5/6/125613339/277521197.png)
Select 'Blanks' and click OK. Excel has now selected all of the blank cells in our first column. Then select Entire row, and click the OK button. Now we have a clean list with no blank lines. If we hop down to the bottom of the list, there are a little more than 33,000 rows, which means we just deleted over. Let's learn how to convert your data to tables and reap the benefits. How To Make a Table in Excel Quickly (Watch & Learn). Click inside the table to select it. Then, click on the Design tab on Excel's ribbon. On the left side of this menu, find the Table Name box and type in a new name for your table.