From the course: Excel: Tips and Tricks (2023)

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Copy data or formulas down a column

Copy data or formulas down a column

From the course: Excel: Tips and Tricks (2023)

Start my 1-month free trial Buy for my team

Copy data or formulas down a column

“

- [Instructor] It's not uncommon in Excel that when you work with formulas, you often need to copy a formula down a column. And in this worksheet called Employees on our Chapter 1 file, we need to put in some formulas in column K. We've got a compensation column in column J. In column K, we're going to be calculating the new compensation. Everybody's going to get a 2.73% increase. So I'll zoom in here holding down Control using the mouse wheel and write a formula. Column K probably doesn't ultimately need to be this wide, but for the moment, let's make it wider so we can see the formula better. There are multiple ways to write this formula. Certainly one way is =J2 times this amount. Now many of you know if we're going to be copying this down the column, we need to make sure that this L1 remains constant or absolute. And we can either manually put in dollar signs or simply press the function key F4. So if I were…

Contents