Setting the appropriate browser height size is the best way to capture a screenshot of the entire spreadsheet. If you don't know the exact height, you can use an approximation.
Also, make sure to check "full page" option.
Hope that works! Let me know if you have additional questions. Happy to help!