Work smarter, not harder!
Microsoft Excel– As an Excel user, do you want a quick way to change a relative cell reference to an absolute or mixed cell reference? Instead of manually adding dollar signs ($$) to a formula to create absolute and mixed cell references, use this tip!
Use a Keystroke to Change Cell References to Absolute, Relative, or Mixed
- Click in the cell containing the formula to change. The formula is displayed in the Formula Bar.
- In the Formula Bar, click the cell reference to change; or,
click next to the cell reference to change; or,
select the cell reference to change.
- Press [F4] enough times to toggle between the reference styles available: Absolute – $C$14, Mixed – C$14, Mixed – $C14, Relative – C14.
- When the desired reference is displayed, press [Enter].
Watch the video below and see how to use a keystroke to change cell references.
If you need help or information about the tip, contact us and we will be happy to go over it with you.