Change the names of columns in a table

Out of category
1

Hello

I created a general table with about thirty columns. At the bottom of each column I want to insert an equation (SUM (A1:A5)... But after the Z column the columns are named: [ or \  and there it is a problem in the function: (SUM([1:[5) for example does not work.

Is there a possibility to change the name of the columns to AA,AB for example?

Thank you

 

I did not specify that I created this table in Solidworks

2

The best thing to do in this case is to convert the table to a table, by selecting the table and going to the "Insert" menu, then Tableau

3

Hello

 

I don't see any Software associated with your question, to be modified so that we can best answer your question. 

 

Bastien

4

What raton proposes is a solution. But I can do it without that, see my attached file.


exemple.xlsx
5

I am attaching a screen view of the Solidworks table. I have circled in red the names of the columns that are causing problems. and in green the "sum" function as it appears.


probleme_table_solidworks.jpg
6

Apparently beyond Z the sums no longer work.

Even the column has made the addition of column A...  o_O

 

One solution would be to make a new table every 26 columns (or less!)