View Single Post
 
Old 12-31-2016, 06:09 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

@ Pecoflyer

That was my line of thought too, but from a search for Excel shortcuts, according to this ExcelJet page, under the FORMULAS part....

Quote:
Paste name into formula

When you're editing a complex formula, the last thing you need is to have to leave edit mode to go find the name of a named range or constant. With this shortcut F3 (no Mac equivalent so far as I know, sorry!) you don't need to. Just press F3 and Excel will open the named range dialog box so that you can paste in the name you need.
Reply With Quote