Dragging & Dropping a range of cells

**mge** · 11-01-2010, 08:38 PM

I can drag & drop a row. I can drag & drop a Column. but how do I do both in one go. I am using Excel 2008 for Mac. Please help guys, many thanks

**davesexcel** · 11-01-2010, 08:40 PM

Would that not be the same as dragging and dropping a range of cells?

**mge** · 11-01-2010, 09:42 PM

Yes dave you are right!

**davesexcel** · 11-02-2010, 02:33 AM

You want to highlight a row and highlight a column at the same time and move them at the same time?
Or
Do you want to just highlight a range of cells and move them?

**mge** · 11-02-2010, 02:55 AM

Thanks Dave, I have a formula in cell A1 which contains some absolute references and some not. I want to drag the contents to a range of cells from say cell A1 to EC59. I can do a drag and drop for one single column or I can drag and drop a single row but it sure would help to do it in one swoop.

**royUK** · 11-02-2010, 02:58 AM

Originally Posted by mge

Thanks Dave, I have a formula in cell A1 which contains some absolute references and some not. I want to drag the contents to a range of cells from say cell A1 to EC59. I can do a drag and drop for one single column or I can drag and drop a single row but it sure would help to do it in one swoop.

That reads like dragging one cell to another. Do you mean that you want the references to change? Or the range A1:EC59 to another destination?

**mge** · 11-02-2010, 03:48 AM

Roy I can drag the contents of A1 thru a column say A1:A59 ok and the contents of all the other cells ie: A2:A59 change to the correct formula as required. Now I can repeat this for every single column up to EC59 as wanted. But it takes a lot of time what I want is some way to do this in one sweep From A1:EC59.Thanks

**royUK** · 11-02-2010, 04:48 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!