ToolsOptionsEdit tab, check Extend data range formats and formulas
Read HELP to make sure how it works

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rose" wrote in message ...
|i have a spreadsheet in excel 2003 that i use to figure trucking miles and
| the rate for those miles. it is done in alphabetical order. when i need to
| add a row, how do iget the formula to apply to that row like the others.