Excel: Range Names

In Excel, you can name your cells and ranges of cells with more user friendly names. This comes in handy as your spreadsheets become more complex. It also comes in handy when you are sharing spreadsheets between co-workers.

File download available here: checkbook

This file is simple enough. I have an example checkbook with monthly salary and monthly expenses listed.


Select cell containing the monthly salary(B3). Now go up to the cell name box (circled in red)


Type a new name in the box – I used “Income”


You can do the same thing with a range. Select cells D3- D5, then rename it “Expenses”


If you check the drop down from the name box, you will see your new named cells in the drop down.


Let’s uses our new named cells (and ranges) to make a quick formula.




To see a video of this lesson, click the link here: Excel: Name Ranges

Please Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s