Absolute Referencing in Excel

This method helpful to multiply multiple values with a particular value. You can See in below image. The list 1 values are added by 4, value of cell B2. In this case, we will use symbol $ in the formula.

To use this method first put formula in cell then press F4 key. $ Sign will appear in the formula. See in below image in cell C2 $ sign appear after this press Enter key to get the result. Now drag the fill handle from cell C3 till cell C7. All values of list 1 will get divisible with 2.

Vlookup in Excel Copy Sheet1 Data in Sheet2

Insert Page Break in Excel Set Password in Excel

Find Date Difference in Excel Change Cell Colour based on Value

Print Top Row on Every Page in Excel Set Auto Row Size in Excel

Prev Tutorial Next Tutorial

Google Advertisment

Sitesbay - Easy to Learn

Absolute Referencing in Excel

Absolute Referencing in Excel

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs