•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I have a problem when trying to delete rows on a table.
Our take
Struggling to delete multiple rows in Excel while filtering your table can be incredibly frustrating, especially when it leads to lag and unresponsive actions. This common issue often arises when trying to clear out old data while maintaining your focus on relevant entries for the year 2024. Fortunately, there are efficient strategies to streamline this process and enhance your productivity. In this guide, we’ll explore practical solutions to help you manage your data effectively and regain control over your Excel experience.
When i filter my table and i wanna delete multiplte rows at the same time excel beggin to lag and i cant even delete any fkin row .
Know that i m filtring the table by multiple standard year 2024 to delete old data and another data so do yu have a solution please
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Rows in file not getting deletedI am working on a data set where suddenly I am unable to delete few rows in between. As in only the data in the cells are getting deleted but the empty row is still present. Tried ctrl & -, manually deleting, tried converting to table and deleting. Tried all methods suggested by chat gpt and co pilot. This is a simple data set with values in general, text, number and date format. What is irritating is this is affecting all the other sheets in the same file. The only alternative solution now which is working is copying the entire data set everyday to a new sheet and then reworking. Can anyone explain why exactly this is happening. Been working with excel for few years and being unable to find the exact RCA is ruining my peace. Update: Unable to add rows as well. submitted by /u/dex_lab [link] [comments]
- Excel Online... is there a way to stop users from deleting rows/columns but still allow them add and delete text from cells?Ok, I'm pretty stuck on this one and am not sure why. I'm using Excel Online (yea, I know... it sucks). I'm attempting to create a filterable table in A1:M1000 that users can enter data into. Where I'm stuck is this... I want users to be able to enter/delete (delete by selecting an entire row and hitting 'delete'), use drop downs, and filter A:M all within that range. I do not want them to be able to edit anything outside of that range (so N -> beyond and 1001 -> beyond) AND I do not want them to be able to add or delete rows/columns across the entire sheet. My hiccup is coming here... how do I lock the sheet while allowing users to add data to A1:M1000, select a row and hit 'delete', but NOT add or delete rows/columns? I've attempted to lock the entire sheet but unlock A1:M1000; however users then cannot select and entire row and hit delete. Anyone have any helpful tips for this? submitted by /u/Tacticool_Turtle [link] [comments]
- Cannot Delete a Row, It Only Clears the RowJust like the title says. When I go to delete a row in my spreadsheet, It only clears the data, does not delete the row. I recognized the error last night and have spent 6 hours creating an exact replica of the file today. It has happened again and I am absolutely livid right now. Anything I look up seems to never have had an actual solution. Does anyone have any idea of what may be going on? This is a spreadsheet I use for College Basketball and was hoping to have done, and up and running already. submitted by /u/TheTroubledBadger [link] [comments]
- Cant delete row after making table (?)https://preview.redd.it/70l6bzktnuqg1.png?width=620&format=png&auto=webp&s=0bf62b64c3fe832f9bb819b15c1f49f03950e0a6 Hi! I accidentally made a table from some of my data, but now I can't delete row 93. I've tried a few things that normally work, but it seems to persist. Does anyone have any idea of what I can try next? Thanks!!! submitted by /u/moosemankiller [link] [comments]