Absolute Referencing in Excel

Advertisements

Prev Tutorial Next Tutorial

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.

absolute referencing in excel
Prev Tutorial Next Tutorial

Google Advertisment

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


For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

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

Advertisements