I would like the total to lock in the cell C1

You can add the formula to the Default Values and make the C1 a Read Only in the widget settings page. Here's a screenshot guide that you can follow:

Here's my demo form: https://form.jotform.com/73404915228961

You can clone it by following this guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

Let us know if you have questions or need further assistance. Thank you.

To make the cells not fillable (read-only), you just have to put them in the read-only section of the Spreadsheet widget:

If you need to make them red like this:

Then you can insert this code to your custom CSS of the widget:

#D1,#D2,#G1,#G2,#I1 {

    background-color: red;

}

Here is my test form so you can check: https://form.jotform.com/73411481765963

Let us know how it worked.

Thank you!

It's perfect, in fact, throughout the year, I will use this form to make online commitments and change based on events. When I look at submissions in PDF (SEE NEXT IMAGE) I would like in this PDF file to replace: A by SOLO B by TECHNICAL SOLO C by DUOS and all the columns as in the form display. thank you very much and good day

Here is how to change the titles of the columns:

Let us know if you need any further assistance.

Thank you!

I did not speak well because I do not speak English well, I want to change the name of the column but only in the PDF of submissions

A replaced by SOLO
B replaced by DUO
C replaced by TEAM
I attach the screenshot so you can better understand cordially

I understand the problem.

The issue is that column names are changed with CSS.

And that you cannot change in PDF.

So the solution would be to adjust that table so the labels are in the first row and first column, something like this:

And it would look like this in the email:

and I'm afraid that there is no way to change that since those are default fields of the widget.

If the above works for you, please let us know so we can apply it to your form.

Thank you!

Very well, I will work on this issue for you. And I will let you know once I finish.

Thank you!

Please check your form now https://form.jotform.com/YGU/PRE-ENGAGEMENTS-LIGUE and let us know if that works for you.

Thank you!

I'm afraid we cannot fix that, it is how the Spreadsheet widget is represented in the Excel, it has nothing to do with the above changes I did.

Also, the Spreadsheet is the best option for what you need, we do have some other table fields that will show better in the excel, but you will then have some other options missing, for example, calculations, setting default values etc.

Let us know if we can be of any further assistance.

Thank you!