How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Richard Your Own Question
Richard
Richard, Computer Software Engineer
Category: Programming
Satisfied Customers: 58221
Experience:  Computer Software Specialist
32989067
Type Your Programming Question Here...
Richard is online now

I have a spreadsheet containing people's ages. For the

Customer Question

I have a spreadsheet containing people's ages. For the following year I would take a copy of the spreadsheet and want to advance everyone's age by 1. Is there a way in Excel to select a column and add 1 to each cell in that column? Hope you can help Thanks
JA: What version of Excel are you using?
Customer: 2010
JA: Have you updated Excel recently?
Customer: Not to my knowledge , No.
JA: Anything else you want the Microsoft Office Expert to know before I connect you?
Customer: No that will do fine thnks
Submitted: 14 days ago.
Category: Programming
Expert:  Richard replied 14 days ago.

Hi there and welcome to Just Answer, my name is Richard and I look forward to helping you.

I’m sorry to hear you're having trouble. I know that can be frustrating. Hopefully, we can get this resolved quickly.

Yes you can, for example if the ages are in Column A then in Column B you would put in for example B1

=A1+1

Then copy this down the entire column.

Let me know how you go please

Customer: replied 14 days ago.
Yes perfect . Thank you very much
Expert:  Richard replied 14 days ago.

You are welcome