moving and dragging multiple cells together without merging?


P

pete321

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
 
Ad

Advertisements

G

Gord Dibben

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.
 
Ad

Advertisements

P

pete321

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

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top