What is absolute cell reference (ACR)?

This is a recommends products dialog
Top Suggestions
Starting at
View All >
Language
French
English
ไทย
German
繁體中文
Country
Hi
All
Sign In / Create Account
language Selector,${0} is Selected
Register & Shop at Lenovo Pro
Register at Education Store
Pro Tier Benefits
• Save up to an extra 20% on Think everyday pricing.
• Spend $15K, advance for FREE to Plus Tier with increased benefits.
Plus Tier Benefits
• Save up to an extra 25% on Think everyday pricing.
• Spend $50K, advance for FREE to Elite Tier with increased benefits.
Elite Tier Benefits
• Save up to an extra 30% on Think everyday pricing.
Reseller Benefits
• Access to Lenovo's full product portfolio
• Configure and Purchase at prices better than Lenovo.com
View All Details >
more to reach
PRO Plus
PRO Elite
Congratulations, you have reached Elite Status!
Pro for Business
Delete icon Remove icon Add icon Reload icon
TEMPORARILY UNAVAILABLE
DISCONTINUED
Temporary Unavailable
Cooming Soon!
. Additional units will be charged at the non-eCoupon price. Purchase additional now
We're sorry, the maximum quantity you are able to buy at this amazing eCoupon price is
Sign in or Create an Account to Save Your Cart!
Sign in or Create an Account to Join Rewards
View Cart
Your cart is empty! Don’t miss out on the latest products and savings — find your next favorite laptop, PC, or accessory today.
Remove
item(s) in cart
Some items in your cart are no longer available. Please visit cart for more details.
has been deleted
Please review your cart as items have changed.
of
Contains Add-ons
Subtotal
Proceed to Checkout
Yes
No
Popular Searches
What are you looking for today ?
Trending
Recent Searches
Hamburger Menu
skip to main content
{"backgroundColor":"#e6f4fa","sideMsg":"","data":[{"bannerInfo":{"t_id":"Page2a2c555b-2734-4355-8eec-d9c479b40f01","language":{"en_nz":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3ENeed%20Help%3F%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20href%3D%22tel%3A0800%20446%20833%20Option%20%232%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECall%20us%20on%200800%20446%20833%20Option%20%232%3C%2Fa%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3Bor%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20href%3D%22https%3A%2F%2Finside.chat%2FLenovoNZ%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3Echat%20with%20us%3C%2Fa%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3Bfor%20order%20related%20help%20and%20access%20to%20special%20deals!%3C%2Fspan%3E%3C%2Fp%3E","en":""},"id":"Page2a2c555b-2734-4355-8eec-d9c479b40f01"}},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page36d69f70-f2ec-476f-863e-9c4e5be34e5b","language":{"en_nz":"%3Cp%3E%3Cimg%20src%3D%22https%3A%2F%2Fp3-ofp.static.pub%2Ffes%2Fcms%2F2022%2F09%2F20%2Fsgy8gw8u4tymopd8g2224x0drocvbb133978.png%22%20alt%3D%22zip-logo%22%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3BWanting%20to%20use%20ZIP%3F%20Chat%20with%20us%20or%20call%20us%20on%200800%20446%20833%20option%232%3C%2Fspan%3E%3C%2Fp%3E","en":""},"id":"Page36d69f70-f2ec-476f-863e-9c4e5be34e5b"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page09849dc3-d4f3-45ec-a81a-1c1654234a7c","language":{"en_nz":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3C%2Fspan%3E%3Cstrong%3ELenovo%20Education%3C%2Fstrong%3E%20%7C%20Register%20to%20unlock%20savings%20%26amp%3B%20benefits%20on%20study-friendly%20PCs%20and%20accessories.%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%3C%2Fspan%3E%3C%2Fspan%3E%3Cbr%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Ca%20href%3D%22https%3A%2F%2Fwww.lenovo.com%2Fnz%2Fedu%2Fnzeducation%2Fen%2Flogin%2Fanzedu%2F%22%20target%3D%22_blank%22%20title%3D%22SIGN%20UP%20OR%20LOG%20IN%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3EJoin%20Lenovo%20Edu%3C%2Fa%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3B%7C%3C%2Fspan%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22https%3A%2F%2Fwww.lenovo.com%2Fnz%2Fen%2Flenovo-edu%2Fstudent%2Fbenefits%2F%22%20target%3D%22_blank%22%20title%3D%22SIGN%20UP%20OR%20LOG%20IN%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3EAbout%20Edu%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Page09849dc3-d4f3-45ec-a81a-1c1654234a7c"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page8e645a5d-196a-4254-929c-408c16a7cf48","language":{"en_nz":"%3Cp%3E%3Cspan%20style%3D%22color%3A%20rgb(0%2C%200%2C%200)%3B%22%3EYoga%20Slim%207i%20(14%26%2339%3B%26%2339%3B%2C%20Gen%209)%20%7C%20Unlock%20seamless%20AI-powered%20creativity%20with%20Intel%C2%AE%20Core%E2%84%A2%20Ultra%20processors%20in%20a%20thin%2C%20light%20design%20with%20epic%20battery%20life.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fp%2Flaptops%2Fyoga%2Fyoga-slim-series%2Fyoga-slim-7i-gen-9-aura-edition-15-inch-intel%2Flen101y0051%3FipromoID%3Dhellobar_04_Yoga-Slim-7i-Gen-9%22%20target%3D%22_self%22%20textvalue%3D%22Pre-order%20Now%22%20style%3D%22color%3A%20rgb(0%2C%200%2C%200)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(0%2C%200%2C%200)%3B%22%3E%3Cstrong%3EPre-order%20Now%3C%2Fstrong%3E%3Cstrong%3E%3C%2Fstrong%3E%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E","en":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3EYoga%20Slim%207%20AI%20PC%20%7C%20Level%20up%20your%20creativity%20with%20next-gen%20AI%20experiences%20on%20the%20new%20Lenovo%20Yoga%20Slim%207x.%26nbsp%3B%26nbsp%3B%3C%2Fspan%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3E%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22https%3A%2F%2Fadmin.lenovo.com%2Fp%2Flaptops%2Fyoga%2Fai-pc-series%2Fyoga-slim-7x-gen-9-(14-inch-qualcomm)%2Flen101y0049%3FipromoID%3Dhellobar_nz_04_AI_PC%22%20target%3D%22_self%22%20textvalue%3D%22Shop%20Now%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3E%3Cstrong%3EShop%20Now%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fp%3E"},"id":"Page8e645a5d-196a-4254-929c-408c16a7cf48"},"gInfo":""}],"autoRun":true,"displayTerminal":"pc,tablet,mobile"}


What is absolute cell reference (ACR)?

ACR is a way of specifying the location of a cell in a spreadsheet program such as Microsoft Excel or Google Sheets. When a cell is referenced using ACR, its location is fixed and does not change when the formula or function that references it is copied or moved to another cell. This ensures that the same cell is always used in the calculation regardless of where the formula or function is placed. ACR is denoted by using the dollar sign ($) before the column and row coordinates of the referenced cell in the formula or function.

Why would I need to use ACR?

You would use ACR when you want to refer to a fixed cell or range of cells in your formula, regardless of where the formula is copied or moved.

How do I use ACR in Microsoft Excel?

In Excel, you can create an ACR by adding a dollar sign ($) before the column letter and/or row number of the cell you want to lock. For example, if you want to lock the reference to cell A1, you will write it as $A$1.

What does the dollar sign ($) signify in an ACR?

The dollar sign in an ACR signifies that the reference is fixed and won't change when you copy or move the formula. It acts as an anchor, keeping the reference constant.

What is an example of when I would use ACR?

Let’s say you have a spreadsheet with sales data, and you want to calculate the total sales for each product. You have the product prices in column B and the quantities sold in column C. To calculate the total sales for each product, you would multiply the price by quantity. By using ACR, you can lock the references to the price and quantity columns while copying the formula to calculate the total sales for other products.

How would I create an ACR for a quantity column?

To create an ACR for a quantity column, you would select the cell reference in the formula and add a dollar sign before the column letter. For example, if the quantities are in column C, the ACR would be $C.

How would I create an ACR for a price column?

To create an ACR for a price column, you would select the cell reference in the formula and add a dollar sign before the column letter. If the prices are in column B, the ACR would be $B.

If I want to multiply the quantity in cell C2 with the price in cell B2, what would the formula look like using ACR?

The formula would look like =$B$2 * $C$2. By using ACR, you ensure that when you copy this formula to calculate the total sales for other products, the references to the price and quantity cells remain fixed.

What happens if I do not use ACR and copy the formula to calculate the total sales for other products?

If you do not use ACR and copy the formula, the references will adjust relative to the new location. For example, if you copy the formula with relative references from cell D2 to D3, the formula will automatically adjust to =$B$3 * $C$3. This may not give you the desired result as you want to multiply each product's price and quantity.

Is there a shortcut to apply ACR in Excel?

Yes, there is a shortcut to apply ACR in Excel. After selecting the cell reference in your formula, you can press the F4 key on your keyboard to cycle through the available reference types (e.g., absolute column and row, absolute column only, absolute row only, relative reference). This makes it quicker to toggle between absolute and relative references.

Can I use ACR in other spreadsheet software besides Excel?

Yes, the concept of ACR exists in other spreadsheet software as well. While the specific method of creating ACR might differ slightly, the purpose and functionality remain the same.

Is ACR only used for calculations?

No, ACR can be used for various purposes beyond calculations. They can be handy when referencing fixed values, such as tax rates, conversion factors, or other constants that need to remain unchanged throughout your spreadsheet.

What is the difference between ACR and relative cell references?

Relative cell references change their position when you copy or move a formula to a different cell. On the other hand, ACR remain fixed and doesn't change regardless of the formula's new location.

Can I mix absolute and relative cell references in a single formula?

Yes, you can mix absolute and relative cell references in a formula. This can be useful when you want to keep some references fixed while allowing others to adjust based on the formula's new location.

Is there a way to lock only the row or column in a cell reference?

Yes, you can lock either the row or the column in a cell reference. To lock only the row, you would add a dollar sign before the row number (e.g., $A1). To lock only the column, you would add a dollar sign before the column letter (e.g., A$1).

Can I remove ACR from a formula?

Yes, you can remove ACR from a formula by editing the formula and removing the dollar signs from the reference. This will convert the reference to a relative reference.

What happens if I delete or move a cell that is referenced with an ACR?

If you delete or move a cell referenced with an ACR, the reference will still point to the original cell location. This can result in errors in your formulas or incorrect calculations. Therefore, it's important to be cautious when manipulating cells that are referenced with ACR.

Can I use ACR to reference cells in different worksheets or workbooks?

Yes, you can use ACR to reference cells in different worksheets or workbooks. When referencing cells in other worksheets, you would include the sheet name followed by an exclamation mark (!) before the cell reference. When referencing cells in other workbooks, you would also include the workbook name along with the sheet name and cell reference.

{"pageComponentDataId":"8be139aba72e3-4860-99ca-6ba970e0d706","isAssociatedRelease":"true","pageComponentDataLangCode":"en_au","configData":{"jumpType":"currentTab","headlineColor":"black","displayNumber":"","styleMode":"vertical","miniCardHoMode":"2","headline":"","products":[{"number":{"t_id":"21kccto1wwnz5","language":{"en_nz":"21kccto1wwnz5","en_au":"21kccto1wwau5","en":""},"id":"Page4260753e-143c-43ae-bd9b-84ae5d0f0dec"}},{"number":{"t_id":"21mccto1wwnz3","language":{"en_nz":"21mccto1wwnz3","en_au":"21mccto1wwau3","en":""},"id":"Page6638705e-acca-4f80-8b27-2e84f2716f0f"}},{"number":{"t_id":"21lkcto1wwnz3","language":{"en_nz":"21lkcto1wwnz3","en_au":"21lkcto1wwau3","en":""},"id":"Page760db0cd-85b7-4d63-b8d8-e3bb500322b5"}},{"number":{"t_id":"21g2cto1wwnz3","language":{"en_nz":"21g2cto1wwnz3","en_au":"21g2cto1wwau3","en":""},"id":"Pagee12208cf-23fd-418f-9456-aae9d4ad753c"}}]},"urlPrefix":"AAAAAAAHAAAB","title":"glossary-right-blue-boxes-fragment","pageId":"e462edae-186e-4421-8743-19efc53941fa","urlEdit":0,"uri":"/FragmentDirectory/glossary/glossary-right-blue-boxes-fragment.frag","pageComponentId":"e857fdeft7e51-4b61-84dc-bccec6e68e00","tplId":"65b55929-de05-417a-a92a-ccb888d329b0","pageComponentUuid":"e857fdeft7e51-4b61-84dc-bccec6e68e00","targetUser":"0"}
coming coming
Starting at
List Price
Web Price
Web Price:
List Price
Web Price
List Price is Lenovo’s estimate of product value based on the industry data, including the prices at which first and third-party retailers and etailers have offered or valued the same or comparable products. Third-party reseller data may not be based on actual sales.
Web Price is Lenovo’s estimate of product value based on industry data, including the prices at which Lenovo and/or third-party retailers and e-tailers have offered or valued the same or comparable products. Third-party data may not be based on actual sales.
Learn More
See More
See Less
View {0} Model
View {0} Models
Part Number:
Features
See More
See Less
compare
Added!
Great choice!
You may compare up to 4 products per product category (laptops, desktops, etc). Please de-select one to add another.
View Your Comparisons
Add To Cart
Add To Cart
We're sorry,
Products are temporarily unavailable.
Continue shopping
Learn More
Coming Soon
Featured Product
Best Deals of the Day
Oops! No results found. Visit the categories above to find your product.
Save
open in new tab
© 2024 Lenovo. All rights reserved.
© {year} Lenovo. All rights reserved.
Compare  ()
x