Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bm
 
Posts: n/a
Default why is there 256 columns on excel?

im wondering why there is 256 columns and 65536 rows on microsoft excel/
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

It was based on memory bytes:

256 = 2^8 or 2*2*2*2*2*2*2*2

8 binary bits, or one byte, can store the integers 0-255 (i.e., 256
numbers).


65536 = 2^16 or 2*2*2*2*2*2*2*2*2*2*2*2*2*2*2*2

16 binary bits, or two bytes, can store the integers 0-65535 (i.e,.
65536 numbers).

So internally, each cell address had a representation that requires
exactly 3 bytes - one for column, and two for row.



In article ,
"bm" wrote:

im wondering why there is 256 columns and 65536 rows on microsoft excel/

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 11:05 PM
How do i copy columns of data in notepad into excel? JJ Excel Discussion (Misc queries) 1 February 10th 05 09:21 PM
Why does my excel have numbered columns and rows DLYNN Excel Discussion (Misc queries) 1 January 22nd 05 12:20 AM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"