A simple query

[virtualized]

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

 

[Luke M]

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.

 

[virtualized]

Dear "Luke M"

Thanks a lot. The problem has been solved.


Best Regards