•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Over 1 million rows - how to delete blanks?
We have an Excel file that was exported from Smartsheet. Unfortunately when exported it brought over 1 millions rows - less than 300 rows have data. How do we delete all of the blank rows?
I know we could copy the data we need to a new spreadsheet, but we have already setup formulas, conditional formatting, etc. The file is kind of slow (shared via OneDrive) and we are working to reduce some of the conditional formatting, etc but I think the formulas checking a million rows has to be slowing it down some too.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#blank rows
#Excel
#conditional formatting