software

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 quot;pick-upquot; the formula as well as the formatting
?
Thank you !
Ian--
IanW
------------------------------------------------------------------------
IanW's Profile: www.excelforum.com/member.php...oamp;userid=31366
View this thread: www.excelforum.com/showthread...hreadid=513996Hi IanW

Click on Tools|Options, select the Edit tab, make sure that Extend list
Formats and Formulaw are ticked

quot;IanWquot; wrote:

gt;
gt; To simplify my query - I enter a formula into A1, copy it down to A10
gt; and format the cells. I insert a row at say A5. The inserted cell (row)
gt; copies the format but not the formula. Is there a way to have the
gt; inserted cell (row) to quot;pick-upquot; the formula as well as the formatting
gt; ?
gt; Thank you !
gt; Ian
gt;
gt;
gt; --
gt; IanW
gt; ------------------------------------------------------------------------
gt; IanW's Profile: www.excelforum.com/member.php...oamp;userid=31366
gt; View this thread: www.excelforum.com/showthread...hreadid=513996
gt;
gt;


Hi Kassie.
Thank you. I'm using Excel 97 and don't have these quot;optionsquot; under
Tools|Options amp; Edit tab. Any other suggestions please.
Ian--
IanW
------------------------------------------------------------------------
IanW's Profile: www.excelforum.com/member.php...oamp;userid=31366
View this thread: www.excelforum.com/showthread...hreadid=513996
I have EXCEL 200, I have quot;Tools|Options, select the Edit tab, make sure
that Extend list Formats and Formulas are tickedquot; and it doesn't work,
either??--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=513996Copy 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