Move a column up or down

  • Thread starter Thread starter MLOO55
  • Start date Start date
M

MLOO55

Sometimes i need to move a specfic column one line up or down, m
quetios is how ro do it? of course i know how to insert o delete
column but the column itself one line up o down
tks
mloo5
 
I assume you mean you want to move a ROW up or down? You can copy the row
and insert it back where you want it.
 
You're leaving some of this for guesswork. You're talking about
inserting/deleting columns, and also about moving them up/down. Do you mean
rows? You can't move all of a column (like A1:A65536). Do you want to move
part of a column (like A5:A10)? Up/down? Do you want cells that would get
overlaid to move to the other side, or be overlaid and wiped out? Do you
think the U.S. should reconsider it's position about the International
Criminal Court?
 
Barb, ML,

You can hold Shift as you edge-drag the selected row, and it'll make a hole
for the new location, and delete the hole left behind. All in one
operation. No cells will be trashed in this process.
 
besides the other replies, you might find the following provides an
overview and directions to moving rows, columns, cells with the mouse.
Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse


MLOO55 said:
Sometimes i need to move a specfic column one line up or down, my
quetios [question] is how ro do it? of course i know how to insert o[r] delete a
column [row] but the column itself one line up o down
Click to expand...

For which we all suffer because excelforum gets searched by Google as a web site
besides where one should be searching for newsgroup posts in Google Advanced Groups.
 
Back
Top