Adding data to Excel cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba to check cell contents 1
Summing rows using formulas with variables 1
Macro to clear contents of certain cells 4
Conditionally formatting text and numbers differently 1
Sum of non-numeric data on multiple sheets 3
Array Function to do a Sum of VLookUps that translate a letter gra 3
converting text cell to numeric cell 5
How to split numeric result of a formula in a cell into 2 cells? 2

Back
Top