Skip to playerSkip to main content
ExcelTips247
  • 1 year ago
Discover how do I click and move columns in Excel. Or how do I click and move columns in Excel. I will also be answering question on how do you shift a column position, or how do I move columns without replacing? From this tutorial you can finally can have the answer to can a column be shifted. Astounding YES!.

Here are the steps outlined on this video.

Move Data Column (Paste)
1) Select the column you want to move.
2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.
3) Drag the column to a new location.

Shift Data Column (Insert Cut Cells)
1) Select the column you want to move.
2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.
3) Shift and drag the column to a new location.

Copy Data Column (Copy & Paste Cells)
1) Select the column you want to move.
2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.
3) Ctrl and drag the column to a new location.

Shift Row (Insert Cut Cells)
1) Select the row you want to move.
2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.
3) Shift and drag the row to a new location.

Copy Data Row (Copy & Paste Cells)
1) Select the row you want to move.
2) Hover over the selection's edge until the cursor changes to a 4-sided arrow.
3) Ctrl and drag the row to a new location.


How do I click and move columns in Excel?,How do you shift a column position?,How do I move columns without replacing?,How do I drag down an entire column?,Can a column be shifted?,What is a shifting column?,
move columns in excel mac,how to move columns in excel,why cant i move columns in excel,how to move columns in excel with keyboard,how to automatically rearrange columns in excel,excel reorder columns by value,excel rearrange columns by name,how to move columns in excel without replacing,

Category

📚
Learning
Transcript
00:00Here's a really neat trick on how you can move or reposition your column. First
00:03highlight the column and then move your cursor somewhere at the edge of the
00:07highlight here where you have four arrows like this. Now you hold your left click
00:12and you drag and you can actually move your column around. Let me undo this guy
00:16here. Let's say if you want to reposition your column, highlight the
00:19column and hold on your shift as soon as you get these four arrows and then left
00:23click and you drag and you can see your column has been repositioned. Let me undo
00:28this again and to duplicate the column, highlight the column, move your cursor
00:32somewhere at the edge where you get four arrows like this, control and then left
00:36click and then move to wherever you want to copy and you can see column B has been
00:41duplicated to column F. You can do the same technique on rows as well. If you want to
00:45let's say reposition a row, highlight the row, hold down shift, make sure you have
00:49four arrows and you reposition wherever you want to and likewise duplicate,
00:53highlight the row, control and then move wherever you want to reposition or copy
00:58over.

Recommended