View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Formula Question for Excel

Let's say that your mark-up is 15%. Select an empty cell somewhere and
enter 1.15 in that cell. Select the cell again and click <copy, then
highlight all the cells that you want this mark-up to apply to and
Edit | Paste Special | Multiply (check) | OK then <Esc. This will
increase all the highlighted cells by 15%, and you can remove the 1.15
from the original cell. Repeat for the other sheets.

Hope this helps.

Pete

On Sep 19, 3:18 pm, Formula applied to whole spreadsheet? <Formula
applied to whole 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.