| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Rows
To simplify my query - I enter a formula into A1, copy it down to A10 and format the cells. I insert a row at say A5. The inserted cell (row) copies the format but not the formula. Is there a way to have the inserted cell (row) to "pick-up" the formula as well as the formatting ? Thank you ! Ian -- IanW ------------------------------------------------------------------------ IanW's Profile: http://www.excelforum.com/member.php...o&userid=31366 View this thread: http://www.excelforum.com/showthread...hreadid=513996 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Rows
Hi IanW
Click on Tools|Options, select the Edit tab, make sure that Extend list Formats and Formulaw are ticked "IanW" wrote: To simplify my query - I enter a formula into A1, copy it down to A10 and format the cells. I insert a row at say A5. The inserted cell (row) copies the format but not the formula. Is there a way to have the inserted cell (row) to "pick-up" the formula as well as the formatting ? Thank you ! Ian -- IanW ------------------------------------------------------------------------ IanW's Profile: http://www.excelforum.com/member.php...o&userid=31366 View this thread: http://www.excelforum.com/showthread...hreadid=513996 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Rows
Hi Kassie. Thank you. I'm using Excel 97 and don't have these "options" under Tools|Options & Edit tab. Any other suggestions please. Ian -- IanW ------------------------------------------------------------------------ IanW's Profile: http://www.excelforum.com/member.php...o&userid=31366 View this thread: http://www.excelforum.com/showthread...hreadid=513996 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Rows
I have EXCEL 200, I have "Tools|Options, select the Edit tab, make sure that Extend list Formats and Formulas are ticked" and it doesn't work, either?? -- roger_home ------------------------------------------------------------------------ roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434 View this thread: http://www.excelforum.com/showthread...hreadid=513996 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Rows
Copy the cell above or below it, or any cell in the series in that
column, and paste it into the new cell. My problem is that it doesn't always copy the format, but copying/pasting will do that also. ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting alternate blank rows in Excel | Excel Discussion (Misc queries) | |||
| Using absolute cell refernce and inserting rows | Excel Worksheet Functions | |||
| Inserting fillable Rows within a Protected Worksheet | Excel Worksheet Functions | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Inserting Rows w/formulas question | Excel Worksheet Functions | |||
Linear Mode
