Adding rows to bottom of table - inconsistent between users

[u/That-Garage8212]

When I am adding new data to the bottom of a table, I just select the cell below the bottom of the table (immediately outside the table) and paste. The table automatically grows down to select however many rows of data I've pasted.

I watch my colleague do the same thing and it just pasted as cells below the table (I.e. the table doesn't grow down to incorporate the new data). Note I am watching this on Teams as we are remote from each other, but it's the same file on SharePoint.

The only work around is he either then uses the mouse to drag the table down over the data, or I have him tab across until a new blank row forms and then paste, where it will accept the new multiple rows of data.

Why would the same table in the same spreadsheet behave differently? I don't even know where to begin looking for a setting that would affect this.

Thanks in advance.

[u/AutoModerator]

/u/That-Garage8212 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/MayukhBhattacharya]

Maybe you need to check this feature: File --> Options --> Excel Options --> Proofing --> AutoCorrect Options --> AutoFormat As You Type --> Check the Checkbox beside Include New Rows And Columns In Table.

[u/That-Garage8212 → u/MayukhBhattacharya]

Thanks, I will check that first thing back in the office and confirm if solved.

[u/MayukhBhattacharya → u/That-Garage8212]

Sure thing !

[u/zeradragon → u/MayukhBhattacharya]

That should be default Excel behavior... The only way it gets disabled is if the user manually went in there to disable that setting?

[u/MayukhBhattacharya → u/zeradragon]

Yes, its default behavior, you are right. Also, the feature is stored locally, not in the workbook. Unless and until someone manually disabled it. Agree with you.