Define Names and Use Them in Microsoft Excel

Microsoft Excel allows any cell to have a defined name, which makes creating and pointing to that cell a lot easier. For example, in a traditional formula you may subtract the value in cell A1 from B1 by using the formula =sum(A1-B1) in cell C1. However, referencing these cells and using them in a formula could be made easier by defining the name of cells. For example, cell A1 could be named total and cell B1 could be named tax, which means the same formula in C1 could be =sum(total-tax) to get the total.

To create a defined name for any cell right-click the cell and choose Define Name, once clicked a New Name window, like the one shown below should appear. Fill out the name you want to use and click Ok.

By defining a name of a cell in your spreadsheet, you will increase your overall productivity since it's a lot easier to remember a name you have defined instead of a cell reference.

What is an Operating System? » Computer Shortcut Keys and their Functions » Keyboard Function Keys » Computer Basics - Hardware - Software - Parts

Short Stories for Kids - Moral Stories – English Short Stories for Children - Moral Stories for Kids - Stories for Kids - Funny Story for Kids - Scary Stories for Kids - Really Funny Short Stories

- Bedtime Stories
Proverb Stories
Powerful Motivational Quotes for Students » Success Quotes » English Short Stories for Kids

Cabin Crew Jobs & Career Advice » Secretary Job Description » Receptionist Job Description » Top 100 Interview Questions and Answers » How to Prepare for an Interview » How to Write a CV » How to Choose a Career » Computer Shortcut Keys and their Functions

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Computer Basics FAQ.

Army Jobs - Navy Jobs - Military Jobs

Scholarship 2024/25

Current Scholarships 2024/2025 - Fully Funded

Full Undergraduate Scholarships 2024/2025

Fully Funded Masters Scholarships 2024/25

PhD Scholarships for International Students - Fully Funded!

Funding Opportunities for Journalists 2024/2025

Funding for NGOs 2024/2025

Funding for Artists 2024/2025

Funding for Entrepreneurs 2024/2025

✅Over 4500 Current Fully Funded Scholarships for International Students

✅ Undergraduate Scholarships 2024

✅ Masters Scholarships 2024

✅ PhD Scholarships 2024 Click Here!

Free Scholarship Newsletter --- E-mail Address

First Name

Then Don't worry — your e-mail address is totally secure. I promise to use it only to send you Advance Africa Newsletter.