Google Spreadsheet Post #1371
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 10, 2013
In other words, I'll paste something like ='Form Responses'!A2 into row 5. I want ='Form Responses'!A3, not ='Form Responses'!A5.
Is there a way to do this?
I'm using Google Docs on Firefox/Windows 8.
----------------------------------------------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 10, 2013
user Greg B. Johnston (http://productforums.google.com/forum/?zx=8h90ovzom3m#!category-topic/docs/spreadsheets/iG9SJ8AMu7Y)
Pasting formula and choosing how many rows to increment?
I have a set of formulas in merged cells that each cover three rows. I want to be able to copy and paste the formula to a spot three rows lower, while only incrementing the cell number in the formula by 1; I'm referencing another sheet, so it's important that I only go down one row of data at a time.Pasting formula and choosing how many rows to increment?
In other words, I'll paste something like ='Form Responses'!A2 into row 5. I want ='Form Responses'!A3, not ='Form Responses'!A5.
Is there a way to do this?
I'm using Google Docs on Firefox/Windows 8.
----------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment