Doesn’t Google Spreadsheet have a function like Excel’s ‘Table’?

Question

In Excel, even if you create a 'table' and add rows to this table, other cells will not be affected.

I would like to implement this feature in Google Sheets, but I couldn't find a table.

If there is no function or concept called 'table', is there any action I can take in the example in the gif below?

(1) When A10 is created by adding a row based on cell A9, values already exist in E10 and F10, and these values are pushed to E11 and F11.

(2) I want the values of E11 and F11 to rise to E10 and F10.

(3) When it comes up, I want the border line aligned with E11 and F11 to be created based on E10 and F10. (What this means is that you want to make it appear as if no rows have been added to other cells.)

Thank you in advance.

Answer 1

There is no-built in solution. The closest possibility is a "Filter" but it won't meet this specific requirement.

In addition, when sharing sheet with other people, you should definitly prevent any unexpected change or mistake (a keystroke made anywhere?) made by user that would destroy your formula/file : add security on your sheet if shared

There is some great work around for adding data in far better manner than right click + adding a row :

1. from cyberbrain : Use of google form for pushing new data.
2. from TheMaster : Right click > Insert cells >Shift down
3. from TheMaster : custom procedure

---

I would like to add more design practice that allow you to avoid that. You should have sheets for presentation purpose and others more data oriented.
For your example :

• a sheet called price
• a sheet called population
• a sheet for sum up data (with lock edit)

The data sheet with data can use the "Filter" as below.

The presentation sheet with ARRAYFORMULA