• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A simple query

virtualized

New Member
Hi Everyone


I have data in a column like below:


3

5

8


I want to add 1 in each cell so that it becomes:


4

6

9


Kindly guide me how can it be done?


Best Regards
 
In a blank cell somewhere, input a 1. Then, copy that cell.

Select the cells you wish to modify, paste special, Select the add function.
 
Back
Top