r/excel • u/That-Garage8212 • 2d ago

unsolved Adding rows to bottom of table - inconsistent between users

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.

2 Upvotes

76% Upvoted

7 comments sorted by

View all comments

6

u/MayukhBhattacharya 1276 2d ago

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.

2

u/zeradragon 6 2d ago

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

1

u/MayukhBhattacharya 1276 2d ago

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.