How many rows of data can one excel sheet capture (versions after 2007)? abhisanto Excel Articles, Excel Tips and Tricks October 12, 2014 1 Minute Question : How many rows of data can one excel sheet capture (versions after 2007)? Answer : 1048576 Share this:TwitterFacebookLike this:Like Loading... Published October 12, 2014