Hi,
I'm fairly new to Excel and would like to know if it's possible to select a row of numbers and with these numbers increase them all by 1 or decrease them all by 0.50 for example.
Is this possible and if so how do I do it?
Many Thanks
Hi,
I'm fairly new to Excel and would like to know if it's possible to select a row of numbers and with these numbers increase them all by 1 or decrease them all by 0.50 for example.
Is this possible and if so how do I do it?
Many Thanks
Try this, type a 1 in an empty cell, copy, select the cells you wish to apply this to, paste/special > Add
Repeat for 0.5
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Wow!
That's exactly what I was looking for.
I spent ages trying to figure it out and I knew I'd seen it somewhere before.
Thanks for your reply and helping me solve this problem so quickly.
Glad to help - thanks for the feedback. May be speak to you again sometime?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks