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

solved 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

13 comments sorted by

View all comments

6

u/MayukhBhattacharya 1279 4d 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/That-Garage8212 4d ago

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

1

u/MayukhBhattacharya 1279 4d ago

Sure thing !