Can't delete excel rows when using select visible cells

Hi,

I'm trying to delete hundreds of rows en-mass using the excel table filter feature to identify the deletable rows, using select visible cells and deleting those rows. This has always worked on windows but now that I'm on Mac I can't do it, it greys out the delete option and won't let me select it!

How can I delete multiple rows like this?

MacBook Pro 16″, macOS 15.4

Posted on Jun 17, 2025 1:13 AM

Similar questions

Numbers - can't unhide rows, can't alter number of rows Can anyone help? My spreadsheet has, supposedly, over 500 rows. I don't want anything like 500, 200 will be enough. I thought the fastest way to delete unwanted rows was to change the number using the format tab - see below But attempting to change that number of 509 does nothing - it won't change! If there really are 510 rows, then where are they? You can see that between rows 185 and 510, there's nothing. I haven't hidden anything! I've tried one thing - that is, delete row 510. That in theory leaves me with 185 rows, yes? But according to that format tab, there are still 509...? Does anyone know what is going on here? Any suggestions appreciated.
957 2
how to move a row in excel I am on matchbook ventura 13.4. I just want to drag and drop to rearrange/move rows in an excel spreadsheet. I have highlighted the row but can find now way to drag and drop/ relocate it
4814 3
Jump to next non empty cell in a row or column In MS Excel in MacOS, I can just hit Command + arrow to move next non empty cell in the direction of the arrow. How do I do this in Numbers? Say I have a spreed sheet with just a single column, but has 1000 rows of data. In that column, 5 cells in random positions are empty, I want just go to those cells without using filtering/formulas/etc.
2873 2

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Can't delete excel rows when using select visible cells

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up