LinkBack URL
About LinkBacks
Okay, I have this table of numbers:
220
223
226
229
232
235
238
241
244
247
250
All I need to do is add a 100 to each of them, so that would mean =A1+100
but what do I do when I want the entire table to be added with a 100?
Okay, I have this table of numbers:
220
223
226
229
232
235
238
241
244
247
250
All I need to do is add a 100 to each of them, so that would mean =A1+100
but what do I do when I want the entire table to be added with a 100?
A very simple way would be to place 100 in a different cell
Select the cell with 100 in it, right click and select copy.
Select the entire table, then right click and select paste special, then select add, then OK
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks