From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

How to use mixed cell references

How to use mixed cell references - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

How to use mixed cell references

“

- [Instructor] When you write formulas in Excel, 2 many times you're using what are called absolute references. 3 And if you've never had the need 4 for an absolute address or a mixed address, 5 you might not even be familiar with the term. 6 In this worksheet, 7 we're going to put in a new salary in column I, 8 let me zoom in on this. 9 I'll hold down Control, use the mouse wheel. 10 Everybody's going to get a 3.1% increase. 11 I need a formula here in cell I2 for the first person 12 and then I'll copy it down the column. 13 And in this formula I will be using cell K1, 14 but I want to be able to write the formula 15 so that I can use K1 repeatedly here. 16 And if you've never seen this, 17 you wouldn't have any instinctive ideas 18 to what to do at first. 19 Start with the formula here. 20 We can write this any number of different ways, 21 equal H2 times this amount and it's in K1. 22 Now even before we finish…

Contents