# How to unstack data in Excel 2007 Excel 2007 and above supports 2 ^ 14 columns, i.e. 16384 columns. They are labeled with the 26 letters of the alphabet, so the labeling is a 26 base system, not a 10 base system like our numbers.

In our 10 based numbering system we have the digits 0 to 9. We start numbering with 1 and the next number after 9 uses another digit and starts that digit at 0. Hence 1, 10, 100. (Strictly speaking, our numbering system should start with a 0 instead of a 1, but that's a different story).

In Excel, columns are numbered with a system that has 26 digits instead of 10.

The first 26 columns are A to Z. The 27th column uses another digit and starts that digit at A, hence AA.

column 26 = Z

column 27 = AA

column 28 = AB

column 29 = AC

...

column 52 = AZ

column 53 = BA

column 54 = BB

...

When all the two-digit headers have been used, another digit is added.

column 702 = ZZ

column 703 = AAA

column 704 = AAB

...

... and finally

column 16384 = XFD

In a 26 base system, the value XFD equals 16384.

Excel 2007 and above supports 2 ^ 20 rows, i.e. 1048576 rows. They are just numbered from 1 to 1048576.

___________________
cheers, teylyn

Community moderator
www.teylyn.com

#### Report abuse

Details (required):
250 characters remaining

·