Paste a range name into an Excel formula

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.

How can I paste a range name into a formula?

Paste a range name into an Excel formula

To paste a range name into an Excel formula (and therefore remove any opportunity for error and save a lot of time), simply press F3 when creating the formula.

The paste name dialog box appears and allows you to select the relevant range name and paste it straight into the formula.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Joe Wallace