Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS
I have a spreadsheet with a column that automatically fills (via formula),
with information from two other columns. This sheet is used to store information, which is top-loaded for chronological entry (I insert rows starting with column 2 to enter new records). When I insert more rows, the formulae is not contained in the appropriate column. Isn't there an option that I can switch so that this does happen? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
auto filling columns from rows | Excel Discussion (Misc queries) |