Excel Tips: Reference a fix cell value while copying cells...

posted by  hjwin (10)  12 months ago (blogs.msdn.com)

This must be pretty normal for people who are using Excel every day, but it is a tip for me that mainly writing code and seldom using Excel. Since my current performance evaluation work need to prepare many calculation reports, Excel becomes a requied tool for this.

Just a simple question while using Excel, that I want to fix one cell value on another formula cell while copying the formula to another rows.

for example o