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

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

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

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

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