I have to show a 7% increase every year. For example C4 is

Customer Question

I have to show a 7% increase every year. For example C4 is =B4*1.07 or C4 =product of (c3,1.07). This requires me to go cell by cell entering this type of formula. Is there a way to make a formula that any cell = the product of the previous cell * 1.07? That way I could enter the same formula in each cell vice typing a new formula in every cell.

With screen sharing session, you would see everything I can do on the screen, and you can stop any time using your mouse.

If not, have you tried this: enter a value in B1 , then set the value in C1 "=B1*1.07", then right-click on C1 cell, then click on Copy, then right-click on the column C (this would highlight the whole column and pop up a menu), then click on Paste, now enter values in column B as needed, and the value should automatically calculate in column C, then does that work?

Edit: It looks like you've gone away; please reply back when you are available to continue. Don't worry, we work in any way you'd like to. You can click on the Reply to Expert tab below, and reply back to me any time, so I can help further as needed. Thank you very much.

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. RobinElkton, Maryland

Ask a Microsoft Office Technician

Get a Professional Answer. 100% Satisfaction Guaranteed.

107 Microsoft Office Technicians are Online Now

Type Your Microsoft Office Question Here...

characters left:

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.