title: Delete Multiple Rows from Table
body: <p>Currently running Excel 2013.  My spreadsheet recently became a table, and it has a few thousand rows of data.  Before I was filtering by a date range then deleting certain rows, and I was using Find &amp; Select->Go To Special->Visible cells only to select all the visible cells and not removed the rows that were filtered out.</p>
  
  <p>Apparently I can't delete multiple rows as a table, is there a way around this?  The option is grayed out, the shortcut ctrl+- doesn't work, I've tried changing a regedit key as per a previous thread.</p>
  
  <p>Is my tragic fate to copy the information into a non-table sheet, edit, copy back to original and reformat as a table?  Please tell me it isn't so.</p>
  
  <p><a href="https://i.stack.imgur.com/wWuZ2.png" rel="nofollow noreferrer">screen crop of the grayed out option after selecting 'visible cells only</a></p>