Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel not copying formulas/formatting to next row?
i have a large table, column A has data validation, M has a formula for calculating based on columns K and L, and O has condifional formatting. basically excel does not automatically copy the formulas down if I start typing on the next blank line on the sheet, despite every single one fo the 1500 rows before it all containing exactly the same formatting and formulas. I thought excel should automatically copy these things down if you start entering on an empty row but it does not. We are using excel 2002 SP2 here. any ideas? -- neowok ------------------------------------------------------------------------ neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940 View this thread: http://www.excelforum.com/showthread...hreadid=313818 |
#2
|
|||
|
|||
Hi neowok
You can use a dataform http://j-walk.com/ss/dataform/ -- Regards Ron de Bruin http://www.rondebruin.nl "neowok" wrote in message ... i have a large table, column A has data validation, M has a formula for calculating based on columns K and L, and O has condifional formatting. basically excel does not automatically copy the formulas down if I start typing on the next blank line on the sheet, despite every single one fo the 1500 rows before it all containing exactly the same formatting and formulas. I thought excel should automatically copy these things down if you start entering on an empty row but it does not. We are using excel 2002 SP2 here. any ideas? -- neowok ------------------------------------------------------------------------ neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940 View this thread: http://www.excelforum.com/showthread...hreadid=313818 |
#3
|
|||
|
|||
Go to Tools/Options/Edit, and check the Extend list formats and formulas.
In article , neowok wrote: i have a large table, column A has data validation, M has a formula for calculating based on columns K and L, and O has condifional formatting. basically excel does not automatically copy the formulas down if I start typing on the next blank line on the sheet, despite every single one fo the 1500 rows before it all containing exactly the same formatting and formulas. I thought excel should automatically copy these things down if you start entering on an empty row but it does not. We are using excel 2002 SP2 here. any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
copying data from Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Copying Tabs in Excel | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
Excel & Copying Formulas | Excel Worksheet Functions |