View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default How do I add a percentage to all cells in a column in Excel?

sorry I relized your salary column probably is in $$ so you can type 1.035 in
a cell and copy --paste special select value & multiply

so if you have 1000 you will have 1035.

now you will have

"JB" wrote:

I have a column of 81 cells all containing different salaries. I need to add
3.5% to all of these cells to show annual raises without doing every cell
inidvidually. Please advise.