Let's say cell K1 has your state sales tax, say 7%
So in a formula you might have =A10*K1 to compute the tax on an item
If you give K1 the name of "tax", you can use =A10*tax
After giving the call the name you can edit the cell with =A10*K1 and use
apply to have it change to =A1*tax
Paste just pastes then name
Now would be a good time to get an Excel book and read more
Notwithstanding the Web, books are not obsolete yet
Or you could Google for "excel name"
best wishes