ProductivitySpreadsheetsTechnologyTipsWork

Spreadsheets: How to copy cells without incrementing the value

When you copy cells in a spreadsheet, it will by default increment the value by one for each entry. For example, if you copy 100, the next entry will be 101, then 102, etc. To copy cells in excel without incrementing the value, add $ in front of the value in the cell.