Autofill

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

Hey all

Is there an easy way to put multiple formulas in one row and have the next
row automaticly format the same way .. without having to pre-copy/paste it
into the cells?

Thanks! :)
 
You can use Excel's Data Form:

Select a cell in the list
Choose Data>Form
Click the New button, and enter the data for the next row. The formulas
will be completed automatically.
 
Thank you for the response,

When I try to do the steps you provided, it tells me I cannot put a formula
in a data field

I should mention I'm using Excel 2003
 
You should enter the headings for the table, then enter the data and
formulas in the first row.
After that, you should be able to use the Data Form
 
Simplified version of my file is:

Col a b c d
e

Portfolio 7/29/2005 / For the Week / YTD / 7/22/2005
abc corp 10,000 +500 8% 9500
def corp 10,000 - 200 4% 10200
mmm 10,000 +100 0% 9900
ppp corp 10,000 +322 -1.2% 9678
xyz corp 10,000 +12 1% 9988
Total 50,000 834 x% 49,266

I have an excel file as above: not shown on the right end are all the
previous weeks.
Each week, I copy/insert b1-b20 to the Column E (so previous week slides
to the right) then I update the leftmost column with current week. My "For
the week " column is c2 = b2 - e2. I want it to stay so. BUT when I
copy/insert col b values to col E, the formula for C2 changes to c2=b2-F2
(following the data)
I want C2 to ALWAYS be c2 = b2 - e2. I want C3 to ALWAYS be c3 = b3 - e3.
(and same for other cels in the c column)
I never want the formula containing E2 to change to F2 on its own

How to "lock the formula" for those cells in col C ? I've tried all the HELP
in Excel/online. Can't find it.
Any guidance ?

Thanks very much.
Bobb
 
Back
Top