I have seen all your 101 videos on excel topic ,really great explanation . Your way of explanation is simply superb sir Any layman can understand the topic. such a nice way of explaining the topic with fluent english 👌👌
Everything is good about explanation and all, but one major concern is , you people dont reply for the questions , are problems ,we face after watching video. Regarding related video.
Very good presentation. I guest it dose not matter whether you name the ranges one by one or group them. When would you use apply names in drop down menu of define Name?
Very good! Thank you! Your videos I very clear and useful. But I want to use (insert) the data from a cell with a specific name range into another cell but to come together with the formatting ( font size, back color,, or frame). For instance,, I have a cell A7 with a letter inside "V" and range name “tt” and frame and red background color. And I go in cell K9 and type tt to appear V with frame and the same back color but not. Appear only V if I type +tt without format. I saw this effect in one Excel template but cannot understand how they did this. Could you advise me on how I can do this, please?
i am trying to give a name of (Lodgeing & Rooming Houses A-1 see Note 3 Less Than 15 m in Height) for a range of sell but it is not accepting.. please help me a suggestion
I have to learn how to update Region name, suppose there are two rows in one row there are country names as England, Scotland, Holland, India, Sri Lanka, Bangladesh. Second row heading is Display, now in that row we have to update region name as EUROPE for England, Scotland and Holland and ASIA for India, Sri Lanka and Bangladesh. How to do this Please help
I wish i get the answer here, so city1 : x1 , x2 , x3 x1 : a1 . a2 , a3 x2 : a1 . a2 , a3 x3 : a1 . a2 , a3 city2 : x1 , x2 , x3 x1 : a1 , a2 , a3 x2 : a1 , a2 , a3 x3 : a1 , a2 , a3 i want to make namerange x1 , x2 , x3 and a1 , a2 , a3 each value from a1 . a2 , a3 is different depends where city at how do i make name range x1 , x2 , x3 and a1 , a2 , a3 with different value in each city with same name range thank you before
@@deepafrancis5148 Sorry If I Hurt You Actually One Of My Friend Whose Name Is Also Deepa Doing Btech From CS Branch Mujhe Laga Bo Hai Isliye Comment Kiya Apka Pic. Clear Visible Nii Ho raha Tha Due To Slow Network
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Is it valid till now?. I need it
I have seen all your 101 videos on excel topic ,really great explanation . Your way of explanation is simply superb sir Any layman can understand the topic. such a nice way of explaining the topic with fluent english 👌👌
You always explain like a professional. Very nice explanation.
EXCELLENT. I HAD NEVER SEEN TEACHER LIKE YOU. BIG FAN OF YOU.
Wonderful video Mr Pavani. Clear and concise. Thanks a lot
Very good and informative series.
There is no method as you usually call in your videos. It is method only
Thank you for your useful videos Sir🙏❤️
In the future you should make and post as many short videos as possible and it will teach us a trick.
Thank you sir for giving a black & white concept..👍
...also, you can use these Named Ranges in formulas and VBA code, not just as a navigation tool.
Thank you sir you solved
my problem
In LibreOffice Calc, Sheets > Named Ranges and Expressions > Create... or ALT + S + N + C.
Very well explained 👏👏🙏🙏
You Deserve More Subscribers
Everything is good about explanation and all, but one major concern is , you people dont reply for the questions , are problems ,we face after watching video. Regarding related video.
Very good presentation. I guest it dose not matter whether you name the ranges one by one or group them. When would you use apply names in drop down menu of define Name?
You are tye BEST🎉🎉🎉
Thank you very much sir...
THANK YOU SIR 😊😊😊
THANK YOU SO MUCH SIR!
Excellent video
Very good! Thank you! Your videos I very clear and useful.
But I want to use (insert) the data from a cell with a specific name range into another cell but to come together with the formatting ( font size, back color,, or frame).
For instance,, I have a cell A7 with a letter inside "V" and range name “tt” and frame and red background color. And I go in cell K9 and type tt to appear V with frame and the same back color but not. Appear only V if I type +tt without format.
I saw this effect in one Excel template but cannot understand how they did this.
Could you advise me on how I can do this, please?
Fantastic lecture sir!
Thank you good sir !
for me name ranges created with first row and first column elements is it correct or wrong sir but for you it is showing only first column sir
Can i use name range in workbook which was created in other workbook.? Kindly guide
Yess we can use space but We can use underscore while editing the Name Range ...what else options we can have???
Thank you😊😊🌹🌹❤❤
Hi, i need a help....how can i make range a varible insted of using Range("A1":"D4") ...i want A,1,D,4 all must be daynamic variable
kindly support
i am trying to give a name of (Lodgeing & Rooming Houses A-1 see Note 3 Less Than 15 m in Height) for a range of sell but it is not accepting..
please help me a suggestion
Great work, thanks a lot.
I have to learn how to update Region name, suppose there are two rows in one row there are country names as England, Scotland, Holland, India, Sri Lanka, Bangladesh.
Second row heading is Display, now in that row we have to update region name as EUROPE for England, Scotland and Holland and ASIA for India, Sri Lanka and Bangladesh.
How to do this
Please help
Beautiful
excellent
Thank you
Viery nice
Super sir
best
Cell range in excel represented by which sign ?? Please tell
I wish i get the answer here, so
city1 : x1 , x2 , x3
x1 : a1 . a2 , a3
x2 : a1 . a2 , a3
x3 : a1 . a2 , a3
city2 : x1 , x2 , x3
x1 : a1 , a2 , a3
x2 : a1 , a2 , a3
x3 : a1 , a2 , a3
i want to make namerange x1 , x2 , x3 and a1 , a2 , a3
each value from a1 . a2 , a3 is different depends where city at
how do i make name range x1 , x2 , x3 and a1 , a2 , a3 with different value in each city with same name range
thank you before
how to split Sachin/kiran/rahul which is one cell.i want filter data by individual name
super sir
IT HELPS A
LOT SIR
Can u tell what is the range of cells for the entire worksheet pls sir
Sir can you understand ms word and ms excel with using urdu language
How to auto highlight cells containing dates, before days/ weeks for us to know expiry dates in advance
Thnxx
Thanku
How to find out designation and department names ? Pls
Nice
thanks
Plz send me Formula of Auto Write ZODIAC name after write Date of Birth ?
What if the I am required to use a digit as the name of the range?
@@mayanksingh8765 does that matter?
Ok
Does that answer my question in any way?
Yeah, you are right.
@@deepafrancis5148 Sorry If I Hurt You Actually One Of My Friend Whose Name Is Also Deepa Doing Btech From CS Branch Mujhe Laga Bo Hai Isliye Comment Kiya Apka Pic. Clear Visible Nii Ho raha Tha Due To Slow Network
Shortcut key for name data range?
How to automatically update Google Sheets data to excel to google sheet
in 2019 there is no datediff function
20/12/23
thanks sir..
Sir, kindly tell me, how to find correct range in Microsoft excel?
Basic dialect -- breaches? Religion of Gov. Double Scales... Under this: Loaned Land Act.
United by taxes. 50 states of: taxes by Natives.
Fffff