I have 4000+ rows data in one column and I want to convert every 10 rows into rows, transpose will not be useful as it is done manually and converting that lengthy (4k+) column will be a neck breaking task, Can any provide a Solution? Admin? Channel?
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
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
Haiii For example Diameter 20 with +/-0.020 and measured value is 19.970/19.980. Here lower value have -0.010mm deviation. Same this how can get in excel? It will be useful to me in work Please help
Right click on the file, choose open with paint, press Ctr+W, type 10% in both height and width, ok the save file. It will reduce size of the file then go to Excel, Data>Data from picture
This looks complicated. Just use =SEQUENCE (range of numbers) e.g. =SEQUENCE(50) gives you a list of numbers 1-50.
What if it's 25 to 50
@@jpfuentes9360 Begin from 25,and step value give 5 or whatever you want.❤
That's why I came to comments to write the same thing
@@jpfuentes9360okay..... same problem here 😅
Thanks for this comment.....👍👍
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)
❤
Thank you
❤
Thanks😊
Yes
Type 1 in a Cell then Press Alt+H+FI+S "Step value=0" - "Stop value=10,000" Select columns and "OK"
Step vlu 0 se nh arha serial num step vLu 1 Se hi hoga
Ward file colum number type tricks de
your comment was the video I actually understood, in THE VIDEO they tried but they failed. :D :) :>
type 1 then select the row wherever u want and jst use alt + EIS
= A1 +1
I use subtotal in order to make more dynamic, atleast when i used filter the number adapt automatically
Sequence formula (only works with new versions)
=A1+1 enter
Drag until you want
Dragging is effort Use =Sequence Formula....🤷
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)
if I want to start numbering from 501 and end at 1000 than how do I do it?
Type 501 in a cell, then alt+H+FI+S. Step value 1 ,Stop value 1000, select columns 👍
@@riyasingh3937 thank
This is not possible for me man
Amazing.. The entire data got deleted
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
hmm kar sakte ho aur koi problem ho to comment kar ke puch sakte ho
Plz don't use Background music
ok but is there any problem
@@focusinguideDistraction....🤷
Click the sheet name bar and add A1000 it will come automatically
Alt + EIS enter
Thanks
😅😅 thanks so mush bro, aj bohot kush hu
Use =sequence instead 😅
sabke paas sequence formula nahi hota
Hi its very useful for me thanks.
You are welcome
Why am I not getting even after trying many times
Because first you have to press 1 inside the column Then press every 4 letters with alt key. like alt + H+F+I+S
Select row of A to write the numbers along with alt +h+f+i+s
Wow wonderful song
I have 4000+ rows data in one column and I want to convert every 10 rows into rows, transpose will not be useful as it is done manually and converting that lengthy (4k+) column will be a neck breaking task, Can any provide a Solution? Admin? Channel?
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
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
Tuyệt vời ❤❤❤❤
I know it very well 😅😅😅😅😅😅
Select any cell... Type 1.. Type =SEQUENCE(300,1) in fx... hit Enter
It's work thank you sir
You have to select column… not row
Haiii
For example Diameter 20 with +/-0.020 and measured value is 19.970/19.980. Here lower value have -0.010mm deviation. Same this how can get in excel?
It will be useful to me in work
Please help
Purila bro
are kehna kya chahte ho ?
It’s not working
Type 1 in a Cell then Press Alt+H+FI+S "Step value=0" - "Stop value=10,000" Select columns and "OK"
ua-cam.com/users/shortseiC1KMqb-zk try this
Very impressive
Alt+hfis for column numbers
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 😂
Can I know you more please, I want to learn more on Microsoft world
you to learn in this channel Like a MS-office course(ms-excel,ms-word-power point, internet and e-mail Writing,Technology videos .
Sir Excel table me mobile no count kese kare, reapet no. Count nhi karne
=COUNT(UNIQUE(A:A))
Bhai itni clear video kaise banai
OBS Studio se video recorder se
Thanks
Can someone please tell me what you use this table for please? I am new to excel
is video ko dekho aap ke liye mene yeh video banaya hai ua-cam.com/video/kzbqbRqZQAU/v-deo.html
Rose is red
Sky is blue
I got scam
He/she got views
So,it is fake and fake
Is it fake🙄
It doesn't work on mine
Its working mam
Alright, I'll be back after trying it. Thanks anyway!
It's not a fake, It's work
type 1 in a cell then press Alt+H+F+I+S , open a New window then step value type 1 and stop value type 10000 then press ok
You can not serious 😅😅😅
what is for mac?
Alt+E+I+S
Thanks man 👍
How to place the serial number on the left side?
Pls explain in details in which columns you want serial number
Thank you
Welcome!
Not working in Office 2007😢
But I want select and delete sr no from 1 to 1200. Can I
Yes of course
Thankieww sir😊
nice one
Thanks for the visit'
How to do like this in mobile pls
aap is video ko dekho khas aap ke liye banaya hai
ua-cam.com/users/shortsaNfBdwX5o8A?feature=share
Row कॉलम दोनो मैं 100 तक गिनती लाने के लिए konsi cey hai
Row ke liye
=SEQUENCE(100)
Column ke liye
=SEQUENCE(1,100)
Serial Number Type Just Second🤟
Formula. =Sequence (rows, columns)
Ex. =Sequence (10000,1)💯✅
Please tel me how to convert 37 MB jpg file to Excel file.... It is urgent
Right click on the file, choose open with paint, press Ctr+W, type 10% in both height and width, ok the save file.
It will reduce size of the file then go to Excel, Data>Data from picture
Nice
Thanks
Nahin Ho pa raha hai counting
Thank you ❤
Welcome!
What is this, who made this video, why that worse background noise, is it any relationship with this
Nice🎉
Thanks 🤗and support
Can anyone suggest me background music name
Hola Como Tale Tale Vu
it's not working in google sheet
Firs you watch the video properly
good
BIG LIKE
Alt + EIS
Instead do this =""&SEQUENCE(1000)
elaborate it please
Deepak Bodana 🚘❤
បង្ហាញលឿនពេក
ខ្ញុំនឹងថែរក្សានៅពេលក្រោយ
😃អរគុណ.ការយកការកែលំអ
Babal thanks ❤❤❤❤
Always welcome
It’s not working.
it's working
mine also not working
Its working
press every 4 letters with alt key. like alt + H+F+I+S
@@fyzanmohammed yes working
Cukup ('1) klik 2x pada kolom
👌👌
Drag chai kunta chudadam avadada anna
There was no better song.
If you can suggest some songs
আসসালামু আলাইকুম ভাই। ইসলামী গজল দিয়েন।
আল্লাহ আপনার মঙ্গল করুক এবং ইসলামের উপর অটুট থাকার তোফিক দান করুক আমিন। ইনশাআল্লাহ।
Olunga podunga da
❤❤❤❤
Didn't worked 😌😌
Type 1 in a Cell then Press Alt+H+FI+S "Step value=0" - "Stop value=10,000" Select columns and "OK"
@@focusinguide but i didn't got step value and stop value column there was blank
It doesn't work on lenovo laptop
@@kibanewme yeah may be
👍👍👍👍👍
please support me and any problem so comments
Song name?
Hola Como Tale Tale Vu
=row(1:10000),enter,搞定
❤😮
Hello
It's really
yes it's work
Alt+f5
Not fake
HFIS
Alt EIS
Nothing happens
not working
Useless music. Ruining the whole thing 😢
😮😮😮HFIS
Not working
first you watch the video carefully
ok i will
Alt + H F I S
Alt+h+f+i
This isn't working lol
plz watch the video carefully
Just Ctrl + E
Fake
This video is not fake, please watch the video carefully.
Ye kl m try kra ni aya 😢
you watch the video carefully
4673h8
Very impressive
Thanks