Get instant live expert help on how many rows can excel handle
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to analyze how many rows contain certain sets of data. For example how many rows contain only 1s vs rows that contain 2s and 3s as well.
Solved by T. J. in 22 mins
I have a large Excel file, about 150MB, with many formulas. In excel 2007, we were able to insert and delete rows fine. In our current Excel, v2016, inserting or deleting rows takes anywhere from 30 seconds to a few minutes. Is there any way we can solve this? The delay in inserting/deleting rows makes many macros unusable.
Solved by M. C. in 25 mins
Hey, I've got a question. I have about columns consisting of 315 rows. Some rows have values in them, some don't. How can I create a formula to show me how many values are in all three rows, combined?
Solved by C. C. in 18 mins
Excel will not fill series even though 'fill handle and cell drag and drop' is enabled. how can I rectify this. it was working fine up until yesterday and the option disappeared.
Solved by C. Q. in 25 mins
How can I get my excel spreadsheet to not have so many rows? There are literally over a million rows (mostly blank) and when I accidentally end up on the bottom of the bottom row, there's no quick way to get back to the last row ithat contains data without scrolling up. I can't pinpoint where to go to because with so many rows, I either get to the very top or the very bottom.
Solved by X. J. in 16 mins