I have an Excel workbook with close to 90 columns. I would like to create column alias for each column in the workbook, so that it will be easier for me to use the respective columns in formulas.
Normally, I would select each column in the workbook and type in my alias for the column into the Cell Reference Bar at the top
Is there a way to do this automatically, because i have a lot of columns? Especially in Python ?
I tried the pandas.Series.to_excel function which has the header attribute. However all it does is change the column names to the string specified and does not modify the alias for all the cells in the column.
Thanks a lot for your help
In Excel, is your data in a table, or named range? 
I'm kind of assuming a table (which could make this a snap) because, as a column heading in a (named) range, the 'header' (or alias, if I understand) isn't "connected" to the underlying data, as it would be in a table...
Can you provide an example of how you would (or expect to) use the 'column alias' in a formula?
How to create common alias for all cells in a column in Excel automatically through scripting