In this tutorial, you will learn how to use absolute cell references in Google Sheets
How To Use Absolute Cell Reference in Google Sheets
A key concept to understand when working with spreadsheets is the importance of absolute cell references. An absolute cell reference means that if you move the cell, the reference will stay the same.
This can be especially useful when you are creating formulas and use the AutoFill tool to copy those formulas.
In this guide, we will show you how to create absolute cell references in Google Sheets.
How To Create an Absolute Cell Reference in Google Sheets
Here’s how to create an absolute cell reference in Google Sheets.
Select the cell you want to convert into an absolute cell reference.
In this example, we want to convert the cell reference to B3 into an absolute cell reference since the shipping fee is a constant throughout all orders.
We can convert the cell into an absolute reference by adding the ‘$’ symbol before the row letter and column number.
You can also use a keyboard shortcut to automatically convert the current cell reference in focus
Windows users can use the F4 key to convert a reference into an absolute reference. Using the shortcut multiple times will toggle between absolute reference and relative reference.
Hit the Enter key to evaluate the function.
Converting any cell reference into an absolute reference will maintain the same result as a non-absolute reference.
The formula can now be copied over a column with the absolute cell reference remaining the same value.
In the example above, the shipping fee of $15 is applied consistently throughout the column.
This guide should be everything you need to create an absolute cell reference in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More Google Sheets collaborations:
- Insert Google Sheets Into Google Docs
- Insert Google Sheets Into Google Slides
- How To Share Google Sheets
- How To Comment
- Share Only One Sheet
- How To Access
- How To Save
- How To Give Access
- See Edit History
- How To Use Google Sheets Offline
- Track Changes
- Turn Off Overwrite
- How To Chat
- How To Tag Someone
- How To Share Only One Tab
- How To Collaborate
- Make A Google Sheet View Only
- Add Note
- Add Comment
- Link To Cells Or Spreadsheets
- How To Link Google Sheets
- Link Google Sheets Together
- Reference Another Sheet
- Unlink Form
- How To Hyperlink
- Create Hyperlinks
- Link Cells
- Reference Cells
- Use Dynamic Cell References