MS Excel - Name Range

MS Excel - Name Range
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani, Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[ramanareddy]

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 👌👌

[Ma_life_snaps]

Real hero on youtube!!!! The way he explains everything single thing really mind-blowing

[sumanjagvanshi]

You always explain like a professional. Very nice explanation.

[TRMNPS]

EXCELLENT. I HAD NEVER SEEN TEACHER LIKE YOU. BIG FAN OF YOU.

[imsodone]

Wonderful video Mr Pavani. Clear and concise. Thanks a lot

[rafsanshereef]

Thank you for your useful videos Sir🙏❤️

[sen-owub]

In the future you should make and post as many short videos as possible and it will teach us a trick.

[subhamgupta]

Thank you sir for giving a black & white concept..👍

[hcarora]

Very useful and time saving trick! HC Arora Vaishali Ghaziabad UP

[smb]

Very good and informative series.
There is no <LONG CUT> method as you usually call in your videos. It is <LONG> method only

[bluefishaddicted]

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?

[Cris-hkcn]

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?

[allabouthh]

...also, you can use these Named Ranges in formulas and VBA code, not just as a navigation tool.

[kannanmassey]

Can i use name range in workbook which was created in other workbook.? Kindly guide

[valliappanlakshmanan]

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

[caanshumantadavi]

In LibreOffice Calc, Sheets > Named Ranges and Expressions > Create... or ALT + S + N + C.

[rahuldamiwal]

Yess we can use space but We can use underscore while editing the Name Range ...what else options we can have???

[shivrajswami]

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

[laharigowda]

Can u tell what is the range of cells for the entire worksheet pls sir