Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am looking for a way to have formulas and cell formats from preceeding rows
automatically entered into inserted rows. I have the Extend formats and formulas option checked but it is not working????? |
#2
![]() |
|||
|
|||
![]() The following MSKB article explains how Auto Extend works, and some of the reasons that it may not work: XL2000: How Auto Extend List Behavior Works http://support.microsoft.com/?id=231002 DippyDawg wrote: I am looking for a way to have formulas and cell formats from preceeding rows automatically entered into inserted rows. I have the Extend formats and formulas option checked but it is not working????? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
Thanks for your reply, however after reading the article I determined why
auto extend was not working - my spreadsheet contains numerous lookup formulas that reference data in other sheets within the workbook. I did do a little more research and found that if I highlight the entire area of data cells and formula cells and make it a list it works just fine. Thanks. "Debra Dalgleish" wrote: The following MSKB article explains how Auto Extend works, and some of the reasons that it may not work: XL2000: How Auto Extend List Behavior Works http://support.microsoft.com/?id=231002 DippyDawg wrote: I am looking for a way to have formulas and cell formats from preceeding rows automatically entered into inserted rows. I have the Extend formats and formulas option checked but it is not working????? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Formats | Excel Discussion (Misc queries) | |||
copy worksheet (keeping formats) | New Users to Excel | |||
Cell Formats in formulas | Excel Discussion (Misc queries) | |||
extend data range formats and formulas | Setting up and Configuration of Excel | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |