Cannot add row in Excel 2010

1152755 pts.
Tags:
Microsoft Excel
My Excel worksheet is formatted as a table. However, I'm trying to add a new row and I can't. It's greyed out. Columns are working fine, just rows. This is on Microsoft Excel 2010.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
It may be you reached the max rows for the version of Excel you are running.
+-----------------+-----------+--------------+---------------------+
|                 | Max. Rows | Max. Columns | Max. Cols by letter |
+-----------------+-----------+--------------+---------------------+
| Excel 365*      | 1,048,576 | 16,384       | XFD                 |
| Excel 2013      | 1,048,576 | 16,384       | XFD                 |
| Excel 2010      | 1,048,576 | 16,384       | XFD                 |
| Excel 2007      | 1,048,576 | 16,384       | XFD                 |
| Excel 2003      | 65,536    | 256          | IV                  |
| Excel 2002 (XP) | 65,536    | 256          | IV                  |
| Excel 2000      | 65,536    | 256          | IV                  |
| Excel 97        | 65,536    | 256          | IV                  |
| Excel 95        | 16,384    | 256          | IV                  |
| Excel 5         | 16,384    | 256          | IV                  |
+-----------------+-----------+--------------+---------------------+

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Are the new rows causing a page overflow?
    135,465 pointsBadges:
    report
  • Subhendu Sen
    Just guess. Please check if the worksheet is protected or not. Also you can try this one, click data menu, filter, show all & check if it helps.
    141,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: