fomulas

G

Gina

I hope someone can help. I set up a spreadsheet. Each
column has a different basic formula. eg column A and
1st line has an amount the column B has a formula of
b=a*2 the 3rd column is c=a*4 and so on down the rows and
column.
My problem is when I enter a number in column A all the
way to line 30 the columns B, C, etc can formulas on its
own. How do I stop it from changing and to keep the
formulas I want.
 
P

Paul

Gina said:
I hope someone can help. I set up a spreadsheet. Each
column has a different basic formula. eg column A and
1st line has an amount the column B has a formula of
b=a*2 the 3rd column is c=a*4 and so on down the rows and
column.
My problem is when I enter a number in column A all the
way to line 30 the columns B, C, etc can formulas on its
own. How do I stop it from changing and to keep the
formulas I want.

Your second paragraph doesn't make sense to me. Could you try to explain in
different words, please?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top