Learn complete cell Referencing in Excel Hindi | How to freeze data | Advanced Excel YouTube Video

In this video, we will learn how to use Cell Referencing in Excel which means when to freeze the data or when to apply a dollar ($) sign to the data. 🔥🔥🔥🔥🔥

There are 3 types of cell referencing in excel: Absolute, Relative, and Mixed Referencing.

Relative Referencing: It is the default referencing in excel where the formula is working dynamically. If the formula is copied from one cell and pasted to the different cell(s), the relative positions of rows and columns will change accordingly. For example – A1

Absolute Referencing: This referencing is used if the user doesn’t want to change the cell reference in the formula in any way. This will keep the rows and column values constant. To apply absolute referencing, the dollar sign ($) is used before row and column. For example – $A$1

Mixed Referencing: It is a part of absolute referencing. If the user wants to fix only a column or a row, then will call it mixed referencing. For example – $A1 or A$1

Download Excel File - https://mdatafinnovatics.com/latest-a...

----------------◀◀◀ YouTube Playlist ▶▶▶------------

ADVANCED EXCEL LATEST VIDEOS - https://bit.ly/3tRuOJ5
EXCEL FORMULAS & FUNCTIONS - https://bit.ly/33lp6UZ
USE MULTIPLE FORMULAS TOGETHER - https://bit.ly/350p0Cy
EXCEL SHORTS | EXCEL TIPS & TRICKS - https://bit.ly/3nx2ojd
EXCEL TOOLS - https://bit.ly/350Dp1z

----------------▪▪◾◼◼Social Media ◼◼◾▪▪------------

WEBSITE LINK - https://www.mdatafinnovatics.com/
YOUTUBE CHANNEL - https://www.youtube.com/mdatafinnovat...
FACEBOOK PAGE -   / mdatafinnovaticsofficial  
TWITTER PAGE -   / mfinnovatics  
INSTAGRAM PAGE -   / mdatafinnovatics  
COMPANY LINKEDIN PAGE -   / mdatafinnovatics  
QUORA - https://www.quora.com/profile/Pradeep...

----------------------⬅◀◼Blogs◼▶➡----------------------

How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - https://www.mdatafinnovatics.com/list...

---------------✉️✉️✉️Contact Us✉️✉️✉️--------------

EMAIL ADDRESS: [email protected]

#mdatafinnovatics #howtofreezedatainexcel #cellreference #excelinhindi