View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Increasing by a percent

Let's say we want to increase a group of cells by 20%.

In an un-used cell enter 1.2 and copy the cell.
Select all the cells we want to increase and then pull-down:

Edit PasteSpecial and check the multiply button
--
Gary's Student


"Nicole" wrote:

How do you increase every number in a spreadsheet by a certain percent with
out changing them each manually?