Moving ranges without changing formulas in adjacent column

ChrisA · May 24th, 2002, 08:09 AM

When I move a range of data down in a column, the formulas in the adjacent column are changed to reflect the move. I want the formulas in the adjacent column to stay the same. Is there a way to do this?

sann0638 · May 24th, 2002, 08:14 AM

Copy and paste then delete?

inarbeth · May 24th, 2002, 08:29 AM

Use absolute references?

Mark W. · May 24th, 2002, 08:34 AM

Copy, Paste and then choose the Edit | Clear Contents menu command with the original range selected. The keyboard shortcut for the Clear Contents command is the Delete key.

sann0638 · May 24th, 2002, 08:45 AM

I meant what Mark said

May 24th, 2002, 08:14 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Copy and paste then delete? __________________ Regards, Mike.

May 24th, 2002, 08:45 AM	#5
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	I meant what Mark said __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 08:09 AM	#1
ChrisA Board Regular Join Date: May 2002 Posts: 50	When I move a range of data down in a column, the formulas in the adjacent column are changed to reflect the move. I want the formulas in the adjacent column to stay the same. Is there a way to do this?

May 24th, 2002, 08:29 AM	#3
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	Use absolute references?

May 24th, 2002, 08:34 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Copy, Paste and then choose the Edit \| Clear Contents menu command with the original range selected. The keyboard shortcut for the Clear Contents command is the Delete key.