View Single Post
  #2   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?

in an empty cell type 3.5% then copy, special paste--select value & add--
select ok

hope it works

"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.