Ask a Teacher
how many coloumns are there in an excel worksheet? |
Every Excel worksheet is limited to 256 columns. Despite what must amount to thousands of requests over the years, Microsoft refuses to increase the number of columns in a worksheet. Beginners often discover this limitation when they want to set up a spreadsheet that contains data for each day in a year. If they store the data horizontally, they run out of column in mid-September. The reason for the 256-column limitation is probably due to the fact that Excel is so old, and it contains lots of code that would be broken if the number of columns were increased. Update: The 256-column limitation was lifted in Excel 2007. In addition, that version has 1,048,576 rows in a worksheet. |