Skip to content

How to Add a Value to Multiple Cells in MS Excel

Need a simple way to add a specific value (i.e. a number) to multiple cells in an Excel Spreadsheet? Here’s a quick way to go about it without having to tinker around with formulas — we only need the paste special to accomplish this.

The steps below will work on Microsoft Excel versions 2007 and later i.e 2010, 2013, 2016, 2019 and 2021.

Steps

Video Tutorial
  1. Insert the value you want to add into a temporary blank cell.
  2. Copy the cell containing the number you just added (note: copy the entire cell so it’s highlighted by the dotted lines and not the number itself).
  3. Select all the cells you want to add to — rows, columns etc. Don’t worry if some contain text or are blank; we can skip over those automatically.
  4. Select the Paste Special… option in the ribbon or press Ctrl+Alt+V.
  5. Select the Add option and click OK.
    A screenshot of the Excel Paste Special window.
    Make sure to check the option Skip Blanks if some of the cells you select are blank. Cells containing text will be ignored automatically.
  6. The value should be added to all the selected cells. You can then delete the temporary cell.
Tags:
Share:

Leave a Reply

Feel free to share your comments or questions with me. I may not be able to respond immediately so please check later once I've approved your comment.

Your email address will not be published.

Kelvin Kathia

Kelvin Kathia is a blogger passionate about finding and sharing solutions to everyday tech problems. He's the founder and editor of Journey Bytes, a tech blog and web design agency. Feel free to leave him comments or questions regarding this post or by leaving him a message on the contact page. If you found his content helpful, a donation is much appreciated.