I'm created a Google Doc posted to the Canvas platform for individual students to record data from an experiment. (see below for screenshot)

In excel, I can easily

  1. insert AVERAGE formula for each row of data
  2. protect all cells except for those where students entered data.

I need to embed that same data entry table from Google Sheets in a Google Doc. However, when I copy the selected table cells from the google sheet, neither the AVERAGE formulas not the cell protection copy over into the Google Sheet.

Neither "paste table with link" to Google Sheet nor "paste unlinked" produces the desired results of
(a) preserving the AVERAGE formula
(b) cell protection

I can do without cell protection, but must have the average formula working.

[Data entry table Google Sheet to embed in Google Doc

  • @serenesat Great edits! Is this an answerable question? Apr 22, 2021 at 14:52
  • Those who have good knowledge on Google Sheet can answer better.
    – serenesat
    Apr 22, 2021 at 16:46


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.