Use Named Constants to Store Numbers


December 3, 2021 - by Bill Jelen

Use Named Constants to Store Numbers

Problem: I’ve seen how to assign a name to a cell. Is it also possible to assign a name to a constant? That could be useful for a number, such as a local sales tax rate, that changes periodically.

Strategy: Yes, you can assign names to constants. To do so, you follow these steps:

continue reading »

More Reading


Create Easier-to-Understand Formulas with Named Ranges

Create Easier-to-Understand Formulas with Named Ranges »

December 1, 2021 - by Bill Jelen


How can I create easier-to-understand formulas?

Learn R1C1 Referencing to Understand Formula Copying

Learn R1C1 Referencing to Understand Formula Copying »

November 30, 2021 - by Bill Jelen


All of a sudden, the column letters along the top of my spreadsheet have been replaced by numbers. None of the formulas I enter will work. What’s wrong?

Simplify the Entry of Dollar Signs in Formulas

Simplify the Entry of Dollar Signs in Formulas »

November 29, 2021 - by Bill Jelen


It is a pain to type the dollar signs in complex formulas such as the formula in the previous topic. How can I make this job easier?

read more articles »

Featured Products


Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.


Excel 2019 Business Basics & Beyond

September 2019

Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.


Excel Dynamic Arrays Straight to the Point 2nd Edition

January 2020

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.


MrExcel 2020 - Seeing Excel Clearly

January 2020

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.


see more products »