Copying Formula only
Posted by Christina O'Neill on September 17, 2001 7:01 AM
I'm creating a spreadsheet to track when employee evaluations are due, based on the employee's start date. I have the formulas written for row 1, the first entry, but want to copy the formula only for the next 99 lines, without having an entry. Two things: when I copy the formula cells, it calculates against the empty data in the referenced cells. Also, if I copy entire rows, and ask to copy formula only, it's copying everything, text and all. Is there anyway that I can copy a formula without having it calculate against empty cells?