excel not copying formulas/formatting to next row?

  • Thread starter Thread starter neowok
  • Start date Start date
N

neowok

i have a large table, column A has data validation, M has a formula fo
calculating based on columns K and L, and O has condifiona
formatting.

basically excel does not automatically copy the formulas down if
start typing on the next blank line on the sheet, despite every singl
one fo the 1500 rows before it all containing exactly the sam
formatting and formulas.

I thought excel should automatically copy these things down if yo
start entering on an empty row but it does not. We are using exce
2002 SP2 here. any ideas
 
Go to Tools/Options/Edit, and check the Extend list formats and formulas.
 
You must log in or register to reply here.

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

Similar Threads

Excel VBA 1
Copy conditional format to rows below 1
retrieving multiple corresponding values with variable rows/column 4
Copy formula with skipping rows 0
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
using the =page! feature to transpose a row to column 0
COPY RIGHT AND TRANSPOSE 2
Incrementing Formula by Column Instead of by Row 1

Back
Top