| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with spreadsheet.
I have put together a spreadsheet containing customer orders. Each row is one
order and has info like start date, finish, ship, Fabrication, Equipment, and delivery dates, Salesmen and so on. Half of the dates and certian other info is automaticaly calculated. My question is when I insert a new row I have to use the Fill Handle to drag down the formula's. Shouldn't they be there after I insert a new row. Every row in the spreadsheet is the same. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with spreadsheet.
Hi
use right click and choose "fill series", you should be alright... -- exalan "Sean.rogers" wrote: I have put together a spreadsheet containing customer orders. Each row is one order and has info like start date, finish, ship, Fabrication, Equipment, and delivery dates, Salesmen and so on. Half of the dates and certian other info is automaticaly calculated. My question is when I insert a new row I have to use the Fill Handle to drag down the formula's. Shouldn't they be there after I insert a new row. Every row in the spreadsheet is the same. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
![Sean.rogers[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
