Switching between relative, absolute, and mixed references in Excel by Chris Menard

Excel has three references: Relative, Absolute and Mixed. You can switch between references using the F4 key or command t on the mac.
Reference descriptions:
Absolute $A$1 Both the row and column are fixed
Mixed A$1 Only the row is fixed
Mixed $A1 Only the column is fixed
Relative A1 Neither the row or column is fixed
Microsoft Article on switching between references:
docs.microsoft.com/en-us/offi...
Chris Menard's website:
chrismenardtraining.com
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZbin keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@famousamos]

Thanks for this Chris. Been a while since my MBA classes on excel basics - just needed a refresher.

[@ChrisMenardTraining]

Glad to help.

[@cassidyjames6325]

Thank you so much for this video, been stuck on homework that made us do mixed references even though we haven't been taught that, and watching this video helped me finally figured out what I've been doing wrong after working on it for 4 hours

[@ChrisMenardTraining]

You are so welcome!

[@user-uf3co5ld6p]

I love your tone, delivery and direct style... You're the Bob Ross of Excel!! :-D haha 👍🙂

[@ChrisMenardTraining]

Thank you. I appreciate it, Adam.

[@JC-jz8gy]

Thank you so much for this, I’ve been sitting I. My chair staining at my computer for hours trying to figure this out. Project assigned was not explain well at all! Thank you times a million!

[@thomaswarms593]

Thank you so much

[@amandashotts404]

You are the best. All of your videos have been so helpful for me.

[@ChrisMenardTraining]

Thank you Amanada.

[@abdulbarekzai2644]

You have explained it very clear bravo!

[@ChrisMenardTraining]

Thank you!

[@adelardnhundesaduka5825]

Thank you.....very nice teaching

[@ChrisMenardTraining]

You are welcome

[@eguebedavid]

This is awesome. Thank you so much sir for these beautiful knowledge shared

[@ChrisMenardTraining]

Thanks, David.

[@swaralakshmi9604]

Thank u so much for this video

[@cdaniels9289]

You were so clear and precise, now I fully understand the difference between them. Thank you so much...😊.

[@ChrisMenardTraining]

You’re welcome 😊

[@imsal1]

Hi Chris thanks for the video, is it possible to add the excel exercise file with all your video so we can go along with you?

[@futuresuperstar4life]

Can you change absolute references that are named cells to relative?

[@Graphicious]

Can you add references across worksheets? Can you please make a video on how to do that? Thanks!

[@ChrisMenardTraining]

I'll put it on my list of upcoming videos. Thank you.

[@bveit]

Chris, I think I have identified a bug. If one creates an ABSOLUTE reference to a cell, and then uses "DATA, SORT" to sort the table, the absolute reference will NOT behave absolutely, i.e., will not follow the cell reference. You can try this and see what I mean.

[@munnathayyil6054]

Grandpa knows mote than me