Friday, December 6, 2013

Can you count them all?

How many columns and rows in Excel?  If you tried to scroll down or right, you might think it is infinite.  But no, the number of columns and rows may differ depending to the RAM of the computer being used.  However, some computers have the same number of rows and columns.  How can you see the end of rows and computers?  Just press END + down arrow key to see the end of rows in Excel.  Same for the columns, just press END + right arrow key to see the end of columns in Excel.  In my computer, the end of rows is row 1048576 and the for the column is column XFD.  You can try this at home! No wonder Excel has many cells.  Can you count them all?

No comments:

Post a Comment