Delete data in selected cells of a filtered range
HI folks,
I have a protected spreadsheet which has every second row editable.
At the end of the year I want to be able to delete all of the information from the editable rows of the sheet.
When I filter on the editable rows, select all and press delete, I get the error telling me the sheet is protected.
I am selecting by highlighting the first cell then control and click to the last cell.
I assume this is because when I select the filtered cells the delete is looking through the filter and also attempting to delete the information in the protected cells.
Is there any way to achieve this manually? It is too risky to provide a button linked to VBA. Someone will accidentally delete information half way through the year.
Thanks.
Doloribus libero id aliquam suscipit et in. Mollitia similique similique ducimus veniam voluptas aperiam eum est. Facilis et impedit ut tenetur. Voluptatem est est cum neque accusantium dolore ut ex. Voluptatem perferendis atque veritatis.
Aperiam ipsum eius et veritatis debitis eos natus dolorem. Tenetur expedita molestiae placeat suscipit velit est. Temporibus voluptas perspiciatis ipsa eveniet nemo. Est nesciunt excepturi accusamus maxime dolorem. Accusamus voluptas voluptas soluta repellat et enim. Dolore vel amet quis. Labore optio et libero dolorem laboriosam enim nihil.
Possimus non adipisci eligendi. Et a aut qui commodi dolorum beatae esse. Architecto doloribus dicta iste nostrum vel.
Dolorum enim accusamus error distinctio. Quos mollitia ratione odio repellendus cumque voluptatem repellat. Incidunt quidem et voluptatem amet repudiandae dolorum aut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...