Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I made a Google Form for assigning a task to myself or a colleague.

For Example:

spreadsheet name: Science, Column 1=Name 2=task 3=due date
spreadsheet name: Mathematics, Column 1=Name 2=task 3=due date

What I need to do is search each spreadsheet (that these forms create) for my name. Then copy the whole row that my name is on so i have all my tasks in one place without having to keep opening every spreadsheet and looking for my name.

share|improve this question

To search for an entry in any Google product, press CTRL + F, and (usually) a find bar will appear in the upper right hand corner of the screen. To copy the whole row, you click on the row (i.e. Row D), which highlights the row. Right click on that row and select 'copy' from the drop-down menu.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.