This article was co-authored by How.com.vn staff writer, Rain Kengly. Rain Kengly is a How.com.vn Technology Writer. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Rain graduated from San Francisco State University with a BA in Cinema.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 10,359 times.
Learn more...
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 How.com.vn 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]
- 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.
- 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]
- This will move the row or column into a new position.
Expert Q&A
Video
Tips
References
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.