Serial Number in excel shortcut || Automatic serial Number in Excel

preview_player
Показать описание
Serial Number in excel shortcut || Automatic serial Number in Excel | Quickly Fill series |#shorts
Рекомендации по теме
Комментарии
Автор

In Home, you can see a option Fill. Just click on it, then click series. Then do fill required start and end serial numbers( HFIS)

jasexplores
Автор

This looks complicated. Just use =SEQUENCE (range of numbers) e.g. =SEQUENCE(50) gives you a list of numbers 1-50.

edimathomas-crkm
Автор

Type 1 in a Cell then Press Alt+H+FI+S "Step value=0" - "Stop value=10, 000" Select columns and "OK"

ishavaggarwal
Автор

type 1 then select the row wherever u want and jst use alt + EIS

rahul_kalran
Автор

I use subtotal in order to make more dynamic, atleast when i used filter the number adapt automatically

unkownwalker
Автор

😅😅 thanks so mush bro, aj bohot kush hu

thomasbasu
Автор

Sequence formula (only works with new versions)

lakhi_kant
Автор

Click the sheet name bar and add A1000 it will come automatically

shinojmknr
Автор

if I want to start numbering from 501 and end at 1000 than how do I do it?

uniquebhutan
Автор

Alt+E+I+S Se bhi ho sakta hain and edit bar main fill ke ander se series se bhi ho sakta hain naa sir

iam_mad_boy
Автор

M delete krne k liye video dekh rhi thi to smj agya ple sari cell ko select kro drag krte hue uske bad keyboard k delete button press krdo sare serial delete hojayenge

reha
Автор

Why am I not getting even after trying many times

Sutrave_Akash
Автор

Jb bhi hm drag kreng 1 dalne k bad to plus sign k pas to us pr click kr k series select krenge tb bhi hojayega 😂

reha
Автор

I have two columns in excel, one is name and other is values, but values are different How do I sort those values into 18 slots approx between 50 to 60? whose sum is 936

rashtrasarvopari
Автор

Sir Excel table me mobile no count kese kare, reapet no. Count nhi karne

Romantic_Love_Songs
Автор

Type 1 in the cell ..press control + enter to stay on the cell then ALT HFIS STOP VALUE 10000- columns (I struggled bfr getting it)

naisharlubega
Автор

Rose is red
Sky is blue
I got scam
He/she got views
So, it is fake and fake

vilakshanjindal
Автор

Can someone please tell me what you use this table for please? I am new to excel

thatdumbguy