Create Custom Autofill Lists a.k.a AutoFill Series in Excel Super Easily
HTML-код
- Опубликовано: 6 янв 2020
- Ever wondered how Excel can easily and quickly give you list of months and days of the week? You never have to write all of them, even a single name is enough and Excel give you the rest once you drag the fill handle.
It is all because of builtin Excel Auto fill lists. And if you don't you know you can make your own Custom Autofill lists to insert data quickly with complete control and convenience.
In this tutorial we are learning how to create Custom Auto Fill lists in Excel in few clicks and will take less than a minute to do so.
!! Get FREE Excel CORE BOOK:
pakaccountants.com/excel-core...
[] For more Excel lessons and tutorials visit: pakaccountants.com/excel/
#MSExcel #CustomAutofillLists #ExcelTricks
This is easily one of the favourite among the tons of Excel tricks! How are you going to use it?
Thank you so much
Thank you
Very good video. Keep up the good work Hassan
Thanks... I was looking for this
very nice trick. thanks for sharing
I Subscribed your channel.... good work
You're doing nice work. Love and support from Hindustan 😊
Appreciate your kind words Dhruv. 😇
How do I fill in this formula automatically for hundreds of rows and has the following structure:
Row1:=SUMPRODUCT(D4:AX4,D6:AX6)
Row2:=SUMPRODUCT(D4:AX4,D7:AX7)
Row3:=SUMPRODUCT(D4:AX4,D8:AX8)
Row4:=SUMPRODUCT(D4:AX4,D9:AX9)
Row 340: .........................................................
ٹیوٹوریل اردو میں بناؤ بھائی جان!