MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Paste Names


August 14, 2017 - by Bill Jelen

Excel Shortcuts - Paste Names

Excel Keyboard Shortcuts: F3 to paste name. This can be useful as you are creating formulas.

I am not a huge fan of this, since you can start typing the name and then choose from AutoComplete. But I know the trick has its fans, include Mike Girvin and Johan van den Brink.

Watch Video

Title Photo: pixel2013 / Pixabay


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.