Uploaded November 2020 | Updated September 2026, 2 weeks ago

---

0:00 Intro
0:14 Trick 1 (Navigate Between Sheets lightning Fast)
1:09 Trick 2 (Copy Paste All Sheet Names Fast)

How To Generate All Microsoft Excel Sheet Names
The Fast And Easy Way Without Any Coding.

Here are the codes used in this example:
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

=index(jaylist,A1)

#ExcelTricks #FreelancerTips #ProductivityHacks



Hi, I'm A Freelance Digital Marketer From Malaysia.
Join me on my journey as a Freelance Digital Marketer.

Subscribe To My Channel:
youtube.com/channel/UCKxxVihjF3Nl3iE97D51NTQ?sub_confirmation=1


Facebook: facebook.com/tiewjinjie.jay
LinkedIn: linkedin.com/in/jaytiew
Twitter: twitter.com/TiewJinJie


My Website: imwithj.com/testimony