G Gord Dibben Oct 29, 2006 #3 More detail is required. What do you currently have in the column and what do want after the increase? If you want to increase all data by the same amount by adding, place the increase in an unused cell. Copy that cell then select the data cells and Paste Special>Add>OK>Esc. To change all by 10% just enter 1.1 in the unused cell then use the the Multiply option from Paste Special. Gord Dibben MS Excel MVP
More detail is required. What do you currently have in the column and what do want after the increase? If you want to increase all data by the same amount by adding, place the increase in an unused cell. Copy that cell then select the data cells and Paste Special>Add>OK>Esc. To change all by 10% just enter 1.1 in the unused cell then use the the Multiply option from Paste Special. Gord Dibben MS Excel MVP
G Guest Oct 31, 2006 #4 Whilst your problem may seem obvious to you, put yourself in our shoes. I could read a dozen differeent things into the few words you ahve written. A well articulated and detailed explanation of the problem usually attracts a similar response.
Whilst your problem may seem obvious to you, put yourself in our shoes. I could read a dozen differeent things into the few words you ahve written. A well articulated and detailed explanation of the problem usually attracts a similar response.