Decorating large tabular forms (10x100)?

Question

css

Hello!
In the current project (web application), there was a need for user-filled reports - forms with a huge number of fields: 9 columns, where the first is a text name, and all other text fields into which numbers are entered, and up to 100 lines, divided into 3-4 groups of 30-50 ... Each group corresponds to a heading.
Yes, you can split the form into several pages (by the same groups), but since all the fields are interconnected and there is a constant count and comparison of all the entered data, there is a double-edged sword here.
The question is how to make a successful design that will simplify filling out such forms and will not let you get lost in an endless set of lines? Alas, I have never been a designer (and, alas, there is no such person around), but at the same time I want to make a practical thing.
I'm using Twitter Bootstrap, I thought about the color separation of groups, I use the Affix plugin from bootstrap for navigation. But all this is clearly not enough.
Does anyone have any good examples?

Answer 1

I imagine that it would be convenient to do this in Google Docs ... The big problem here, in my opinion, is not in the design, but in filling such a massive page by half, not losing all the data due to an accidental page refresh. Tobish builds all data at once to send ajax to the server.
And so, the main thing is that your 10 columns fit on the screen, and their headings are visible anywhere on the page (either repeat or hang as a static line)