Inserting Rows

I

IanW

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
 
K

Kassie

Hi IanW

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

IanW

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
 
R

roger_home

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??
 
E

edcosoft

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
 
Top