How to Stop Excel from Automatically Creating New Rows and Columns in Table?

Microsoft Excel automatically makes new rows and columns, If you open an Excel worksheet and start working on a table. Though, if you want to prevent Excel from automatically creating new rows and columns in the table, it is possible to turn off this feature.

You can stop Excel from automatically making infinite rows and columns in the table using Excel Options, Group Policy Editor, or Registry Editor.

This risewindows article will guide you on preventing Excel from automatically creating new rows and columns. You can apply these methods on Windows 11/10 or other operating systems.

How to Prevent Excel from Automatically Creating New Rows and Columns in Table using Excel Options?

Do these steps to stop Excel from automatically making new rows and columns in a table using Excel Options:-

Step 1. Open Microsoft Excel.

Step 2. Pick on the File menu.

Step 3. Pick Options.

Step 4. Switch to the Proofing tab on the Excel Options window.

Step 5. Pick the AutoCorrect Options button under the “AutoCorrect options” section.

Step 6. After that, the AutoCorrect window will open. Switch to the AutoFormat As You Type tab and uncheck the checkbox from the “Include new rows and columns in table Automatically as you work.”

Step 7. Pick OK button.

Step 8. Press OK button again.

How to Stop Excel from Automatically Creating New Rows and Columns in Table through Local Group Policy Editor?

Do these steps to stop Excel from automatically making new rows and columns in a table through Local Group Policy Editor:-

Step 1Open Local Group Policy Editor on Windows 11 or 10 computer.

Step 2. Navigate to the following path in the left sidebar of Local Group Policy Editor:-

User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Proofing > Autocorrect Options

Step 3. Double-click on the policy name Includes new rows and columns in the table on the right side of the “Autocorrect Options” folder.

Step 4. Choose Disabled option.

Step 5. Click Apply button.

Step 6. Hit OK button.

Step 7. Restart your computer to apply the changes.

How to Block Excel from Automatically Creating New Rows and Columns in Table using Registry Editor?

Do these steps to block Excel from automatically making new rows and columns in a table through Registry Editor:-

Step 1. Open the Registry Editor.

Step 2. Navigate to the following path on the left side of Registry Editor:-

HKEY_CURRENT_USER\Software\Policies\Microsoft\office\16.0

Step 3. Right-click on the 16.0 folder to choose New > Key.

Step 4. Name the new key excel.

Step 5. Right-click the excel folder to pick New > Key. Name the new key as options.

Step 6. Right-click on the options key to choose New > DWORD (32-bit) Value.

Stop 7. Set its name as autoexpandlistrange.

Step 8. Double-click on the newly created autoexpandlistrange REG_DWORD and set its “Value data” to the following:-

  • 0: Allow Excel to create new rows and columns in Table automatically.
  • 1: Block Excel from creating new rows and columns in Table automatically.

Step 9. Hit OK.

Step 10. Restart your computer to apply the changes.

Thank You, friends, for your time.

You guys are amazing; Keep reading, learning, and growing.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: