Tips & Tricks 13 – Copy and Paste All Defined Names in the Sheet

You are wondering that if you can copy and paste all defined names in the sheet. Do following

1. Formulas Tab > Use in Formula > Paste Names

2. Click on Paste List to paste all defined names.