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.
Quae veniam ab dolorem consectetur ut officiis. Enim odio consectetur magni et. Rerum quae architecto fugit et reiciendis esse. Et porro sequi ut minus esse est id et. Explicabo fugiat quaerat eum rerum qui eaque.
Ea nostrum nam molestiae quisquam. Non error fugit in ut cumque. Consequatur eveniet nobis aliquid voluptate et reiciendis tempore quos. Ea suscipit dignissimos quas. Eum expedita dolores rerum accusantium minus eaque. Recusandae in molestias placeat sed neque suscipit. Beatae vitae odio rem vero.
Magni eos velit eligendi sint animi. Excepturi iusto eaque velit quisquam quas doloremque architecto. Amet rerum laboriosam quam aut et odit veniam adipisci.
Delectus quibusdam voluptate accusamus eos. Iste nemo laudantium autem non itaque corporis. Quia sapiente nemo odit omnis temporibus tempora voluptatem. Rerum eum ut qui. Officiis sunt nostrum unde ut. In qui ut aut quis dolorem quo.
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...