I will never understand why Microsoft Excel goes to ‘IV’ instead of ‘ZZ’
Do you really want to know? Because I can tell you.
IV = I in the 26s place, and V in the 1s place = (9 x 26) + (22 x 1) = 234 + 22 = 256.
That is to say that “IV” is the way of writing base-26 for 256 (base-10)
You’ll note that 256 = 2^8 = 1 byte’s (8 binary bits are one byte, an important basic block-size of data for computers) worth of columns in a single sheet.
You’ll note that classic Excel stops at 65,536 rows per sheet as well. 65536 = 2^16 = 2 bytes’s worth of rows.
You probably didn’t actually want to know that, did you?
But it’s fun! Binary counting, bits/bytes and computer registers, it’s all fun. Right? Right?