It all depends on how your equations look. For example, say you are selling
flooring and the price per square foot installed is $6.99 and this value
appears all over the place in many separate cells. Now you want to increase
this by 5% to $7.34.

Edit Replace
6.99 in the Find what box
7.34 in the Replace with box
Replace All

Every occurance of 6.99 will be replaced with 7.34.

If there are many different prices, but they are all in a single column
table, then put 1.05 in an un-used cell. select this cell and copy it. Then
select the the table of values and paste/special/mulitply. This will update
all the values in the table by 5%.

If there are lots of prices scattered all over the place, you are in trouble.

--
Gary''s Student - gsnu200745


"Formula applied to whole spreadsheet?" wrote:

I work for a boat dealership and I am making spreadsheets for pricing. I
have our net figures entered on multiple sheets and now I need to mark up
those prices and produce new spreadsheets that reflect retail pricing for our
sales staff. Is there a way to insert the same formula throughout the whole
page and mark each cell up accordingly? I am trying to avoid having to go to
each cell and type in our mark up equation. Any help is appreciated! Thanks
in advance.