Download Article
A quick guide to rearranging a single or multiple rows and columns in Microsoft Excel
Download Article
Do you want to move rows around in Microsoft Excel? If you mistakenly entered a row or column of data in the wrong place, you can easily move it without replacing it. You can use a mouse to drag it to a new location, or you can use a few keyboard shortcuts. This wikiHow will show you how to move an entire row or column in Microsoft Excel using your Windows or Mac computer.
Things You Should Know
- On Windows, select a row or column. Hover over the border to change the cursor into a move pointer. Hold "Shift" and drag to a new position.
- On Mac, select a row or column. Hover over the border to change the cursor into a hand icon. Hold "Shift" and drag to a new position.
- On Windows, you can also select a row/column and press "CTRL" + "X". Right-click a new location and click "Insert Cut Cells".
Steps
-
Open a spreadsheet in Microsoft Excel. You can use an existing project or create a new spreadsheet .
- If you don't have the desktop application, you can use the online web version at https://www.office.com/ .
- You can use Excel to make tables , type formulas , make graphs , and more.
-
Select a row or column. Use the numbers on the left side of the spreadsheet to select an entire row, or use the letters at the top of the spreadsheet to select an entire column.Advertisement
-
Hover your cursor over the border of the selection. When done properly, the cursor will change into a move pointer (four arrows pointing each direction).
-
Hold ⇧ Shift and drag the row to another location. Make sure to drag from the border; the cursor should still be a move pointer. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- This will cut and insert the row or column into a new position.
-
Use commands (optional). You can also move rows with commands. Do the following:
- Select the row or column you want to move.
- Press CTRL + X to cut. The selection will be highlighted in a moving border.
- Right-click the row below or column to the right of where you want to move the selection.
- Make sure to click the first cell of the row or column.
- Click Insert Cut Cells .
- The selection will be cut from its original position and pasted above the selected row or to the left of the selected column.
Advertisement
-
Open a spreadsheet in Microsoft Excel. You can use an existing project or create a new one.
-
Select a row or column. Use the numbers on the left side of the spreadsheet to select an entire row, or use the letters at the top of the spreadsheet to select an entire column.
-
Hover your cursor over the border of the selection. When done properly, the cursor will change into a hand icon.
-
Hold ⇧ Shift and drag the row to another location. Make sure to drag from the border; the cursor should still be a hand icon. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- This will move the row or column into a new position.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Thanks to all authors for creating a page that has been read 19,509 times.
Advertisement
