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 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
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
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" 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 👌👌
Real hero on youtube!!!! The way he explains everything single thing really mind-blowing
You always explain like a professional. Very nice explanation.
EXCELLENT. I HAD NEVER SEEN TEACHER LIKE YOU. BIG FAN OF YOU.
Perfect explanation
Wonderful video Mr Pavani. Clear and concise. Thanks a lot
Thank you for your useful videos Sir🙏❤️
Very useful and time saving trick! HC Arora Vaishali Ghaziabad UP
Very well explained 👏👏🙏🙏
In the future you should make and post as many short videos as possible and it will teach us a trick.
You Deserve More Subscribers
Thank you sir for giving a black & white concept..👍
Very good and informative series.
There is no method as you usually call in your videos. It is method only
Excellent video
You are tye BEST🎉🎉🎉
Thank you sir you solved
my problem
Thank you very much sir...
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.
THANK YOU SO MUCH SIR!
THANK YOU SIR 😊😊😊
Fantastic lecture sir!
In LibreOffice Calc, Sheets > Named Ranges and Expressions > Create... or ALT + S + N + C.
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?
Thank you😊😊🌹🌹❤❤
...also, you can use these Named Ranges in formulas and VBA code, not just as a navigation tool.
Thank you good sir !
Can i use name range in workbook which was created in other workbook.? Kindly guide
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?
excellent
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
How to recorder the names?
Great work, thanks a lot.
IT HELPS A
LOT SIR
How can I protect name manager from being deleted by anyone ?
super sir
Super sir
Beautiful
Yess we can use space but We can use underscore while editing the Name Range ...what else options we can have???
Can u tell what is the range of cells for the entire worksheet pls sir
Thank you
how to split Sachin/kiran/rahul which is one cell.i want filter data by individual name
Viery nice
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 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
Sir can you understand ms word and ms excel with using urdu language
How to find out designation and department names ? Pls
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
Cell range in excel represented by which sign ?? Please tell
Thnxx
best
Shortcut key for name data range?
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
Nice
How to auto highlight cells containing dates, before days/ weeks for us to know expiry dates in advance
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
Thanku
thanks
Plz send me Formula of Auto Write ZODIAC name after write Date of Birth ?
How to automatically update Google Sheets data to excel to google sheet
in 2019 there is no datediff function
thanks sir..
20/12/23
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