G Guest Nov 14, 2007 #1 I want to be able to add numeric data to numeric data already in specific cells, without doing an addition in my head.
I want to be able to add numeric data to numeric data already in specific cells, without doing an addition in my head.
N Niek Otten Nov 14, 2007 #2 enter the data in empty cells. select the cells, Edit>Copy. Select the cells to be added to. Edit>Paste special, check Add. Always try in a copy of your workbook first! -- Kind regards, Niek Otten Microsoft MVP - Excel |I want to be able to add numeric data to numeric data already in specific | cells, without doing an addition in my head.
enter the data in empty cells. select the cells, Edit>Copy. Select the cells to be added to. Edit>Paste special, check Add. Always try in a copy of your workbook first! -- Kind regards, Niek Otten Microsoft MVP - Excel |I want to be able to add numeric data to numeric data already in specific | cells, without doing an addition in my head.
G Gord Dibben Nov 15, 2007 #3 Same data to all cells? Enter a number in an empty cell. Copy that cell then select the range of cells and Edit>Paste Special>Add>OK>Esc. Different numbers to selected cells? How is the layout of your data and the numbers to add to the existing numbers? Gord Dibben MS Excel MVP
Same data to all cells? Enter a number in an empty cell. Copy that cell then select the range of cells and Edit>Paste Special>Add>OK>Esc. Different numbers to selected cells? How is the layout of your data and the numbers to add to the existing numbers? Gord Dibben MS Excel MVP
