How do I insert a row & have the existing formulas apply to new ce

Charity Worker in Africa

Posts: n/a

How do I insert a row & have the existing formulas apply to new ce

I have a table which has a column that uses a formula. When I insert a new
row in the middle of the table, Excel inserts a blank cell into the column
with formulas, rather than keeping the formula that applies to the adjacent
rows.

How do I insert a row and keep the column with a formula so it applies to
that new row?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I insert a row and have the existing formulas apply?	Charity Worker in Africa	Excel Discussion (Misc queries)	6	October 6th 05 10:05 AM
How can I insert a row and have the existing formulas apply?	Charity Worker in Africa	Excel Discussion (Misc queries)	1	October 5th 05 03:43 PM
How can I insert a row and have the existing formulas apply?	Charity Worker in Africa	Excel Discussion (Misc queries)	0	October 5th 05 03:35 PM
INSERT ROWS WITHOUT SCREWING-UP FORMULAS!	BILL GATES - I WANNA WORD WITH YOU!	Excel Worksheet Functions	1	March 4th 05 01:32 PM
Challenging Charting	C TO	Charts and Charting in Excel	0	January 17th 05 06:57 PM

All times are GMT +1. The time now is 07:31 AM.

Menu

About Us