课程: Google Workspace Hacks: Unlocking Digital Productivity

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Copy formulas to other cells

Copy formulas to other cells

课程: Google Workspace Hacks: Unlocking Digital Productivity

开始一个月试用 购买团队方案

Copy formulas to other cells

“

- [Instructor] Once you enter information into a cell in Google Sheets, you have the ability to drag that cell down and quickly copy the information to other cells. For instance, here, let's say I'm filling this out, and I want to type in the word registered. Now, I'd like that word to be in all of these cells. What I can do is click on that cell and in the bottom right, you'll see this little square. If I hover my mouse over it, it turns into that crosshair, and I can drag that down. Say I want to go down to column 25, and just like that, it will copy that text into those cells. Now if you have a list of things, it will copy the list. But if you have a logical list that is, say, counting, it can also do this. Let's say here that I have one, two, three, and I want to keep going down and number this, so I number all of these. Well, I can simply grab a hold of these three cells. Sheets will then be able to identify the logic here. I can grab the little square in the bottom right with…

内容