Inserting rows/columns without messing up formulas

sophos707

New Member
Joined
Dec 4, 2005
Messages
6
Greetings! I look forward to getting to know you all more on this board!
It already looks like there's a ton of great answers!

Here's mine:
I was wondering if there is a way to insert rows or columns without messing up my formulas. Obviously the formulas I have all rely upon Column locations..

For instance I have a number of formulas working with column "E" ... But I need to add a column before E; is there any way to do that and have all the formulas automatically update?

Thanks!
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

jdee

Active Member
Joined
Sep 10, 2003
Messages
276
Just remove the dollar signs from your formula - dollar signs make formula absolute.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,388
Members
412,590
Latest member
Velly
Top