How to drag columns in Excel – As already mentioned, dragging columns in Excel is a bit more complex procedure than one could expect. In fact, it’s one of those cases that can be classified as “easier said than done”. But maybe it’s just my lack of sleight of hand ability 🙂 Nevertheless, with some practice, I was able to get it to work, so you will definitely manage it too. 
- Select the column you want to move.
- Hover the mouse pointer over the edge of the selection until it changes from a regular cross to a four-sided arrow. You’d better not do this anywhere around the column heading because the cursor can have too many different shapes in that area. But it works just fine on the right or left edge of the selected column, as shown in the screenshot.
- Press and hold the Shift key, and then drag the column to a new location. You will see a faint “I” bar along the entire length of the column and a box indicating where the new column will be moved.
- That’s it! Release the mouse button, then leave the Shift key and find the column moved to a new position.
You can use the same technique to drag several columns in your Excel table. To select several columns, click the heading of the first column you need to move, press and hold Shift, and then click the heading of the last column. Then follow steps 2 – 4 above to move the columns, as shown in the screenshot. 
Note. It is not possible to drag non-adjacent columns and rows in Excel. The drag and drop method works in Microsoft Excel 2016, 2013, 2010 and 2007 and can be used for moving rows as well. It might require some practice, but once mastered it could be a real time saver. Though, I guess the Microsoft Excel team will hardly ever win an award for the most user friendly interface on this feature 🙂
Contents
Can you move an entire column in Excel?
How to drag columns in Excel – As already mentioned, dragging columns in Excel is a bit more complex procedure than one could expect. In fact, it’s one of those cases that can be classified as “easier said than done”. But maybe it’s just my lack of sleight of hand ability 🙂 Nevertheless, with some practice, I was able to get it to work, so you will definitely manage it too.
- Select the column you want to move.
- Hover the mouse pointer over the edge of the selection until it changes from a regular cross to a four-sided arrow. You’d better not do this anywhere around the column heading because the cursor can have too many different shapes in that area. But it works just fine on the right or left edge of the selected column, as shown in the screenshot.
- Press and hold the Shift key, and then drag the column to a new location. You will see a faint “I” bar along the entire length of the column and a box indicating where the new column will be moved.
- That’s it! Release the mouse button, then leave the Shift key and find the column moved to a new position.
You can use the same technique to drag several columns in your Excel table. To select several columns, click the heading of the first column you need to move, press and hold Shift, and then click the heading of the last column. Then follow steps 2 – 4 above to move the columns, as shown in the screenshot. Note. It is not possible to drag non-adjacent columns and rows in Excel. The drag and drop method works in Microsoft Excel 2016, 2013, 2010 and 2007 and can be used for moving rows as well. It might require some practice, but once mastered it could be a real time saver. Though, I guess the Microsoft Excel team will hardly ever win an award for the most user friendly interface on this feature 🙂
How do I quickly adjust rows and columns in Excel?
– Do one of the following:
- To change the row height of one row, drag the boundary below the row heading until the row is the height that you want.
- To change the row height of multiple rows, select the rows that you want to change, and then drag the boundary below one of the selected row headings.
- To change the row height for all rows on the worksheet, click the Select All button, and then drag the boundary below any row heading.
- To change the row height to fit the contents, double-click the boundary below the row heading.
Top of Page
How do I move cells in Excel without changing formatting?
How to copy a formula down without copying formatting – Copying a formula down by dragging the fill handle not only copies the formula, but also the source cell formatting such as font or background color, currency symbols, the number of displayed decimal places, etc. 
For prevent overwriting the existing cell formatting, drag the fill handle as demonstrated above, release it, click the Auto Fill Options drop-down menu, and select Fill Without Formatting, 
How do I move everything down one column?
@JellyMyst If your data is in Column A, and you have A1 selected, then the keyboard shortcut Ctrl + Shift + Down Arrow may help in that type of situation, it will select every cell between A1 and the first empty row. If your data has empty rows, you can press Ctrl + End to go to the last cell on the worksheet, then press Home to go to the last cell on Column A, then press Ctrl + Up Arrow to go to the last populated cell in Column A, and finally press Ctrl + Shift + Home to select every populated cell in Column A.
Why can’t I move Excel cells?
– To view all your data, you can scroll smoothly through a worksheet without snapping to the top-left cell in your display. Even if you stop scrolling partly through a row or column, Excel doesn’t advance any further, which is of particular benefit for large cells.
- These improvements work with a mouse, mouse wheel, touchpad, touch screen, or scroll bar drag.
- By default, scrolling is based on the height of one Excel row.
- If you have a precision mouse or touchpad, you can scroll one pixel at a time.
- However, if your Windows mouse option is set to move one line of text for each click of the mouse wheel, it supersedes the Excel behavior.
Tip: If you do need to snap to the top-left cell, use the arrow buttons on the scroll bar, or use the arrow keys on the keyboard to change your cell selection until you get the sheet positioned the way you want.
How do you move a column to a row in Excel?
Updated June 1, 2023 In Excel, select the column you want to switch and copy the selected cells or columns to convert any Columns to Rows. Go to the cell where you want to paste the data. Then, select the Transpose option from the Paste option under the Home menu tab. This will convert the selected Columns into Rows. The shortcut key for paste special: Once you have copied the range of cells that need transposed, click on Alt + E + S in a cell where you want to paste a special dialog box popup window with the transpose option.