RSS

Use apply names to create readable formulas [quick tip]

02 Apr

We all know that using named ranges is a good practice. So you went ahead and created names for every value in your complex workbook. But now, what about those formulas which still refer to cells by their addresses? Here is a quick tip to make your formulas readable by replacing cell addresses with the names in one go.

Use Apply Names feature.

Here is how.

Select the cells containing formulas
Go to Formulas > Define Name > Apply Names
Hold Shift and select all the names
Click OK
Your formulas will now have names instead of cell references
See the demo aside to understand it.

 

image

Do you use apply names feature?

Most of the times, I create names first and then write formulas. But as models or workbooks evolve, I often have to apply names. In all such cases, I use “Apply Names” feature as it is faster and easier.

What about you? Do you use apply names feature? Please share your experiences and tips in the comments section

Source chandoodotcom

Advertisements
 
Leave a comment

Posted by on April 2, 2015 in Excel

 

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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: