Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuing functions
If I have several functions located in columns throughout my spreadsheet, is
it possible to make them continue downwards, so that whenever a user adds a new row, whether it be the 15th or the 1500th, those formulas will still be present. Also, along those same lines, is it possible that when a user enters data into a new row, I can make it so that borders will automatically appear? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuing functions
Sorta.
For the first part, what is commonly done is to setup your formulas with a blank cell check, like =IF(A1="","",YourFormulaHere) For the second part, you can use conditional formatting to create a border. Selecting A2: Format, conditional format, formula is: =A2<"" Click on format, border tab, setup the border you want to appear. Copy formatting to all your current cells, and a significant amount of "future" cell to accomodate future entries. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tech_Wolf" wrote: If I have several functions located in columns throughout my spreadsheet, is it possible to make them continue downwards, so that whenever a user adds a new row, whether it be the 15th or the 1500th, those formulas will still be present. Also, along those same lines, is it possible that when a user enters data into a new row, I can make it so that borders will automatically appear? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuing functions
If I have several functions located in columns throughout my
spreadsheet, is it possible to make them continue downwards, so that whenever a user adds a new row, whether it be the 15th or the 1500th, those formulas will still be present. One way in Excel 2003 is to use Data List Create list Also, along those same lines, is it possible that when a user enters data into a new row, I can make it so that borders will automatically appear? Try conditional formatting, as another responder has already suggested. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Continuing Formula - try 3 | Excel Discussion (Misc queries) | |||
Continuing Headers | Excel Discussion (Misc queries) | |||
Continuing Macro | Excel Discussion (Misc queries) | |||
formulas continuing | Excel Worksheet Functions | |||
set up a continuing roster? | Excel Discussion (Misc queries) |