Named Cells


L

ldodero

Hello, I was hoping someone could answer my question. I've used this
group before with great success:

In older versions of Excel, if a spreadsheet had named cells in it,
those named cells could be inserted into a formula simply by selecting
the name from a drop down list. The down arrow for the list is beside
the formula line immediately above the spreadsheet grid.



In the newer versions of Excel, if a spreadsheet has named cells in
it, those named cells do appear in the drop down list. HOWEVER, once
you begin to enter a formula into a cell (i.e. entering the “=” sign),
the drop down list of names is replaced with a drop down list of
formulas. Where did the list of names go? How does one get them
back?

Thanks!
 
Ad

Advertisements

J

Jim Rech

Press F3 while entering a formula.

--
Jim
Hello, I was hoping someone could answer my question. I've used this
group before with great success:

In older versions of Excel, if a spreadsheet had named cells in it,
those named cells could be inserted into a formula simply by selecting
the name from a drop down list. The down arrow for the list is beside
the formula line immediately above the spreadsheet grid.



In the newer versions of Excel, if a spreadsheet has named cells in
it, those named cells do appear in the drop down list. HOWEVER, once
you begin to enter a formula into a cell (i.e. entering the “=” sign),
the drop down list of names is replaced with a drop down list of
formulas. Where did the list of names go? How does one get them
back?

Thanks!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top