Have you ever wondered how many rows or columns there are in the newer versions of Excel? Or how many characters can I fit in one cell? Wonder no more, here are some of Excel’s max capabilities:

  • Rows: 1,048,576
  • Columns: 16,384
  • Cells in a worksheet: 17,179,869,184
  • Column width: 255 characters
  • Row height: 409 points
  • Total number of characters a cell can contain: 32,767
  • Characters in a header or footer: 255
  • Sheets in a workbook: Limited by available memory
  • Undo levels: 100
  • Items displayed in filter drop-down lists: 10,000
  • Nested levels of functions: 64