Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[tobi1133]

Nice video. i was looking for this big document with the 15 examples in your youtubechannel but what is the name of this document so that i can practics it to.

Thank you

[ExcelIsFun]

@tobi1133 , WAY at the bottom of the page in the OTHER section.

[allchangesintime]

i love your tutorials, thanks!

[ExcelIsFun]

You are welcome!

[ecceservices]

The link you posted on the video to downlaod files doesnt work

Is there a way to get those files?

[ExcelIsFun]

The link does work when i tried it.

Try watching this video (it shows all the tricks for using excelisfun):

youtube[dot]com/user/ExcelIsFu­n

[ilhamideniz]

hi, have a question,

1.) at sheet1 on cell C5 i collect data from sheet2 cell C2, by formatting C2 as

'' =sheet2!$C$2 ''

2.) now, at sheet2 i shift Row 2 down by inserting a new row.

3.) I want in sheet1 at cell C5, still the cell content at sheet2 cell C2.

but, by shifting at 2.) is my cell format at sheet1 cell C5 is changed to

'' =sheet2!$C$3 '' ..... please can you explain me how to prevent this

have nice day,

[ExcelIsFun]

In cell C5, try this formula:

=OFFSET(INDEX(Sheet2!$C:$C,1),­1,)

I do not have a video on why this works, but I will make on in about a week...

[ExcelIsFun]

Try these (even better):

=INDIRECT("'sheet2'!C2")

or

=INDEX('sheet'!1:1048576,2,3)

[ExcelIsFun]

Here , I made this video for you:

Excel Magic Trick 691: Look At Cell C2 No Matter How Many Rows Or Columns You Insert Or Delete

[ALIKALVERT]

you are the man when it comes to making excel sheets

thanks

[ExcelIsFun]

As always: You Are Welcome!!

[hamy72]

Mike you the most altrustic person out there on the net! This tutorials are priceless!

[ExcelIsFun]

I am glad that you like them!

[microsuez]

Hope once a while, you can make a longer video like this one. With more examples related to the subject, it's really help for one to learn Excel concepts better.

Yes, you are awesome and by far the best around. Keep your good works.

Youtubers like ExcelIsFun..................

[ExcelIsFun]

I have 59 other videos similar to this longer / subject orientated video in this playlist:

Highline Excel Class: Beg. To Advanced

If you do not know how to find playlists, search for and watch this video title:

Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun

I will make more longer videos in the future!

[likesahib]

Excellent!

[ExcelIsFun]

EXCELlent!!!

[redballyou]

EXCELlent pun.

[ExcelIsFun]

:)

That sort of fun comes easily with Excel becasue Excel Is Fun!

[UpTick21]

Jolly good pun!!! ;-) LOL

[sully199]

As a Compensation professional your videos are awesome. This will help me a lot when they have me doing analysis paralysis. Thanks again

[ExcelIsFun]

You are welcome!!

[beaniehoke]

I found it easier using the first part of the video. Going across or columns. If I am not sure, I go to the last cell and check. I usually get it right now. I watched the multiplication chart and had a hard time trying to figure it out until now.

thanks a lot. And you are right, I got office 2007 and it is great.

[ExcelIsFun]

Awesome! I am glad to hear that you are practicing a lot! That is the only way that I know how to do it!

Keep up the good work!

[tirathmistry]

Thanks so much for your time For making & sharing This! Your all excel tutorials are awesome & valuable for us

yours is by far the best, not just because what you do is technically superior than others, but becos u are able to explain so clearly that even a newbie like me can look good using Excel !

Keep up good work man

Make more & more tutorials

God Bless you :-)

[ExcelIsFun]

I am glad that you like them! I will keep making them!!!

[tirathmistry]

Thanks! There's so much to be learned from your tutorials. Anyone offering their skills is appreciated, and none are better than yours.

Your tutorials are just great! They really show me I still have a lot to learn about Excel Keep teaching us. Thanks.

God Bless you man

[ExcelIsFun]

You are welcome, tirathmistry!

The great thing about Excel is you always will have some new and wonderful thing to learn! That makes it exciting!

[beaniehoke]

I just watched your business 216 video.

I could not get the cell references. When to lock the rows or the columns. You really explained it good in this video. I watched the whole video. It was great. But you are right, it is hard to learn. Now I think I will be able to do it right the first time I use mixed cell references thanks to you. I give it a 10.

[ExcelIsFun]

I am glad that you are study so hard to learn this hard but extremely useful topic! When I learned, it took me about 6 months before i became fluent. Every time I forgot, I would re-do the multiplication table.

If you were to download the workbook and do all the example a few times, I but it would help cement the concepts!

[kennis942]

came to 07 min, i know this from before , soit got too boring .. sorry.

[ExcelIsFun]

That just means you are an Excel Guru Guy - really smart with excel!

[LotfyKozman]

In this video, you have prepared a table before me as if I am in a five stars hotel. It includes the various kinds of the supreme foods, soups, salads, drinks, and the fine disserts (the art of conditional format).

Anyone visit this video, will find something to eat. Thanks so much for the great Chef— Chief.

[ExcelIsFun]

Cool!

My intention was to have a comprehensive story about Cell References, but your food analogy is awesome!

I just finished breakfast, I better go and have some Conditional Formatting, I mean desserts!!

[UpTick21]

Fantastic job . . . love it!

Uptick21

[ExcelIsFun]

I am glad that you like it. I was worried that the video was too long; however, I wanted one video that would tell a comprehensive story about Cell References.

[chinchonchinchon]

@ExcelIsFun

Being Excel a fun tool, and you being a terrific teacher this video is a delight!

Cell references can be chanllenging to understand at times, but with practice we can become good at it.

[ExcelIsFun]

I am glad that you like it!! And you are correct - this is difficult topic that most people have a hard time with.