What is Name Box?

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 ?
Quick Links
Recent Searches
Hamburger Menu
skip to main content
{"backgroundColor":"#e6f4fa","sideMsg":"","data":[{"pcInfo":{"t_id":"","language":{},"id":""},"mAndTabInfo":"","bannerInfo":{"t_id":"Page94ee33f7-be68-4e3a-b027-f6548057899e","language":{"en_au":"%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%3A13%20LENOVO%20%2F%2013%20536686%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECall%20us%20on%2013%20LENOVO%20%2F%2013%20536686%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%2FLenovoAU%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":"Page94ee33f7-be68-4e3a-b027-f6548057899e"},"gInfo":{"t_id":"","language":{},"id":""}},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page3e63dbd2-63e6-49c3-8b4c-201c5d971e40","language":{"en_au":"%3Cp%3E%3Cimg%20src%3D%22https%3A%2F%2Fp2-ofp.static.pub%2FShareResource%2Fanz%2Fimg%2FMasthead_Carousel%2Flfs-logo--reversed.svg%22%20alt%3D%22logo%22%20width%3D%2290%22%20height%3D%2218%22%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3B24%20months%20Interest%20Free*%20with%20Latitude.%20Call%2013%20LENOVO%2F%2013%20536686%20or%20chat%20with%20us%20to%20place%20an%20order.%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20style%3D%22text-wrap%3A%20wrap%3B%20text-decoration-line%3A%20underline%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECHAT%20NOW%20TO%20ORDER%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Page3e63dbd2-63e6-49c3-8b4c-201c5d971e40"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Paged56756f3-3589-40bc-b752-63a3a890e518","language":{"en_au":"%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%3B17%20months%20interest%20free*%20with%20ZIP.%20Call%2013%20LENOVO%2F%2013%20536686%20or%20chat%20with%20us%20to%20place%20an%20order.%26nbsp%3B%3Ca%20target%3D%22_self%22%20style%3D%22text-decoration-line%3A%20underline%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECHAT%20NOW%20TO%20ORDER%3C%2Fa%3E%3C%2Fspan%3E%3C%2Fp%3E","en":""},"id":"Paged56756f3-3589-40bc-b752-63a3a890e518"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Pagebe06910a-f31e-4fa7-8a56-bee24cf85016","language":{"en_au":"%3Cp%3E%3Cimg%20src%3D%22https%3A%2F%2Fp4-ofp.static.pub%2FShareResource%2FJPResource%2FJP-Images%2Fworkstations-px%2Famazonmusic-unlimited-horizontal-black.png%22%20alt%3D%22Amazon%20Music%20Unlimited%22%20width%3D%22130%22%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3BGet%204%20months%20Free.%20%2412.99%2Fmonth%20after.%20New%20subscribers%20only.%20Terms%20apply.%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fp%2Faccessories-and-software%2Fsoftware-subscription%2Famazon-subscription%2Frr00125299%3FipromoID%3Dau_pc_carousel_banner_amu%22%20target%3D%22_blank%22%20textvalue%3D%22LEARN%20MORE%22%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3ELEARN%20MORE%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Pagebe06910a-f31e-4fa7-8a56-bee24cf85016"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page6ec00a73-b892-4293-8895-1e323f513ee4","language":{"en_au":"%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%20%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3E%26nbsp%3B%3C%2Fspan%3E%3C%2Fspan%3E%3Ca%20href%3D%22%2Fp%2Flaptops%2Fyoga%2Fai-pc-series%2Fyoga-slim-7x-gen-9-(14-inch-snapdragon)%2Flen101y0049%3FipromoID%3Dhellobar_au_04_AI_PC%22%20target%3D%22_self%22%20textvalue%3D%22Shop%20Now%22%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cstrong%3E%3Cspan%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3EShop%20Now%3C%2Fspan%3E%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Page6ec00a73-b892-4293-8895-1e323f513ee4"},"gInfo":""}],"autoRun":true,"displayTerminal":"pc,tablet,mobile"}


What is Name Box?

Name Box is a feature in Microsoft Excel that allows you to create a named range or cell reference. Instead of referring to cells by their traditional column and row coordinates, you can assign a meaningful name to a range of cells or a single cell. This makes it easier to understand and refer to specific data within your workbook.

How does Name Box work?

To use the Name Box feature, simply select the range of cells or a single cell that you want to name. Then, click on the Name Box, which is located next to the formula bar in Excel. Type in the desired name for the range or cell, and press Enter. Once named, you can easily refer to the range or cell by its assigned name in formulas and functions throughout your workbook.

Why would I use Name Box in Excel?

Using the Name Box feature can make your Excel worksheets more organized and easier to navigate. By assigning names to specific ranges or cells, you can quickly identify and refer to important data without having to remember the exact cell coordinates. This can save you time and effort, especially when working with complex formulas or large datasets.

Can I use Name Box in formulas?

Yes, you can use the names assigned through the Name Box feature in formulas. Instead of manually typing the cell references in a formula, you can simply enter the assigned name. This not only makes your formulas more readable but also reduces the chances of errors when referencing cells.

Does Name Box work across multiple worksheets?

Yes, Name Box works across multiple worksheets within the same Excel workbook. Once you assign a name to a range or cell, you can refer to it from any worksheet within the workbook. This allows for seamless navigation and referencing of data, regardless of which worksheet you are currently working on.

What are the benefits of using Name Box?

Using Name Box in Excel offers several benefits:

  • Enhanced readability: Assigning meaningful names to ranges or cells makes your formulas more understandable and easier to maintain.
  • Improved efficiency: By using names instead of cell coordinates, you can quickly navigate through your workbook and refer to data without having to search for specific cells.
  • Reduced errors: Using names in formulas reduces the chances of typographical errors when referencing cells.
  • Flexibility: Name Box works across multiple worksheets, providing flexibility when working with complex workbooks.

Can I edit or delete names assigned through Name Box?

Yes, you can edit or delete names assigned through Name Box at any time. To edit a name, select the range or cell that the name is assigned to, click on the Name Box, edit the name, and press Enter. To delete a name, select the range or cell, click on the Name Box, delete the name, and press Enter. It's important to note that deleting a name does not delete the corresponding cell or range; it only removes the assigned name.

How can I manage and view all the names in my Excel workbook?

Excel provides a built-in feature called the Name Manager, which allows you to manage and view all the names assigned in your workbook. To access the Name Manager, go to the Formulas tab in the Excel ribbon and click on the Name Manager button. In the Name Manager dialog box, you can view, edit, delete, and create new names for your ranges and cells.

Can I use Name Box in other Office applications?

No, Name Box is specific to Microsoft Excel and is not available in other Office applications such as Word or PowerPoint. However, other Office applications may have similar features that allow for named ranges or cell references.

Can I use Name Box to assign names to non-contiguous cells?

No, Name Box does not support assigning names to non-contiguous cells directly. However, you can use other Excel features such as defining multiple named ranges separately and then combining them using formulas or functions to achieve similar functionality. This allows you to work with non-contiguous cells in a more organized and manageable way.

Can I use Name Box to create names for tables in Excel?

Yes, you can use Name Box to create names for tables in Excel. When you convert a range of data into an Excel table, a default name is assigned to the table. However, you can rename the table by selecting it and editing the name in the Name Box. This makes it easier to refer to and work with specific tables within your workbook.

Can I use Name Box to navigate to a named range in Excel?

Yes, you can use Name Box to quickly navigate to a named range in Excel. Simply click on the drop-down arrow in the Name Box, and you will see a list of all the named ranges in your workbook. Select the desired name, and Excel will automatically take you to the corresponding range or cell within your worksheet.

Does Name Box support reference external workbooks?

Yes, you can use Name Box to reference named ranges in external workbooks. When you create a name that refers to a range in another workbook, you can use the complete file path along with the name to ensure accurate referencing. This allows you to work with data from multiple workbooks while using meaningful names to simplify your formulas.

Can I use Name Box in Excel Online or the Excel app for mobile devices?

Yes, Name Box is available in Excel Online and the Excel app for mobile devices. The functionality of Name Box remains consistent across different versions of Excel, allowing you to easily assign, manage, and reference named ranges or cells from your web browser or mobile device.

Can I use Name Box to create names for data validation lists in Excel?

No, Name Box is not used to create names for data validation lists in Excel. Instead, you can create a named range for the list of values and refer to that named range in the data validation settings.

Can I use Name Box to assign names to hyperlinks in Excel?

No, Name Box is not used to assign names to hyperlinks in Excel. Hyperlinks are created using the "Insert Hyperlink" option and can be linked to a range of cells or external uniform resource locators (URLs).

Can I use Name Box to assign names to formula results in Excel?

No, Name Box is not used to assign names to formula results in Excel. Formula results are automatically calculated based on the formulas entered cells.

{"pageComponentDataId":"e857fdeft7e51-4b61-84dc-bccec6e68e00","pageComponentId":"e857fdeft7e51-4b61-84dc-bccec6e68e00","isAssociatedRelease":"true","pageComponentDataLangCode":"en_au","configData":{"jumpType":"currentTab","headlineColor":"black","displayNumber":"","styleMode":"vertical","miniCardHoMode":"2","headline":"","products":[{"number":{"t_id":"21kccto1wwau5","language":{"en_nz":"21kccto1wwau5","en_au":"21kccto1wwau5","en":""},"id":"Pageb33ce4b8-4839-4ba3-b993-7296d68a91b8"}},{"number":{"t_id":"21mccto1wwau3","language":{"en_nz":"21mccto1wwau3","en_au":"21mccto1wwau3","en":""},"id":"Page1fa61927-074c-4fe0-a8df-5c94362fb75c"}},{"number":{"t_id":"21lkcto1wwau3","language":{"en_nz":"21lkcto1wwau3","en_au":"21lkcto1wwau3","en":""},"id":"Pageca014688-410e-439a-a4c6-bba2ef6d4715"}},{"number":{"t_id":"21g2cto1wwau3","language":{"en_nz":"21g2cto1wwau3","en_au":"21g2cto1wwau3","en":""},"id":"Page79cd32c8-d467-4d68-b955-d273bb24eda7"}}]},"urlPrefix":"AAAAAAAH","title":"glossary-right-blue-boxes-fragment","pageId":"65b55929-de05-417a-a92a-ccb888d329b0","urlEdit":0,"uri":"/FragmentDirectory/glossary/glossary-right-blue-boxes-fragment.frag","pageComponentUuid":"e857fdeft7e51-4b61-84dc-bccec6e68e00"}
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
Top 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