sts8500man
Board Regular
- Joined
- Jul 12, 2012
- Messages
- 77
- Office Version
- 365
- Platform
- Windows
New to using Excel Tables. After converting data to a table, I noticed that not all the columns received sequential column numbers. I need to understand how that affects the efficacy of the data / worksheet. More specifically, table column number 1 is actually the fifth column in the table. Several next door columns were not given a column number. Table column number 2 is actually the 10th column. Also, two columns at the end of the table did not receive numbers. Everything seems to work OK. The VBA macros work correctly. The calculations from formulas seems to work OK. I guess I just do not understand the column numbering issue, why the columns are numbered, and what affect column numbers have on the worksheet. Would someone please enlighten me?