moving and dragging multiple cells together without merging?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pete321 - 14 Jun 2006 19:28 GMT

is it possible to do this

say i have a row, A2-F7

there is data in each cell

can i make it so i move any of the cells (lets say C2) up or down and
the whole row will all move in a unit as if it was merged? i dont want
to officially merge though because then that will screw up the data
inside the cells

Signature

pete321

Reply to this Message

Don Guillett - 14 Jun 2006 20:22 GMT

Instead of a cell, use the row counter

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>
> is it possible to do this
[quoted text clipped - 7 lines]
> to officially merge though because then that will screw up the data
> inside the cells

Reply to this Message

Gord Dibben - 14 Jun 2006 20:46 GMT

Pete

A2:F7 is 6 rows, not one row.

To move one row as a unit, highlight the entire row using the row header.

Hover the cursor on the edge of any cell in that row and move when you see the
4-headed arrow.

Gord Dibben MS Excel MVP.

>is it possible to do this
>
[quoted text clipped - 6 lines]
>to officially merge though because then that will screw up the data
>inside the cells

Reply to this Message

pete321 - 14 Jun 2006 21:51 GMT

sorry, meant A2 to F2, nonetheless, row header will allow me to get what
i need done

thanks

Signature

pete321

Reply to this Message