Terecle: Careers, Help & How-To GuidesTerecle: Careers, Help & How-To GuidesTerecle: Careers, Help & How-To Guides
  • PCs & Hardware
    • Laptops
  • Software & Services
    • Communications
    • Productivity
  • PC Games
  • Social Media
    • Facebook
    • Messenger
    • Instagram
    • LinkedIn
    • Snapchat
    • Discord
    • TikTok
    • WhatsApp
  • Tools
    • Office
      • Microsoft Excel
      • Google Sheets
    • Collaboration & Project Management
      • Miro
      • Jamboard
Terecle: Careers, Help & How-To GuidesTerecle: Careers, Help & How-To Guides
Search
  • PCs & Hardware
    • Laptops
  • Software & Services
    • Communications
    • Productivity
  • PC Games
  • Social Media
    • Facebook
    • Messenger
    • Instagram
    • LinkedIn
    • Snapchat
    • Discord
    • TikTok
    • WhatsApp
  • Tools
    • Office
    • Collaboration & Project Management
Follow US
Tools > Office > Microsoft Excel > How to Move Rows in Excel

How to Move Rows in Excel

Ogechukwu Anthony
Last updated: August 7, 2023 6:27 pm
By Ogechukwu Anthony - Editor-in-Chief
Share

Microsoft Excel spreadsheet has a number of uses, it is used for calculation, computation, graphing, pivot tables, and a host of other features it can be used for. When working with data in Excel, users may need to move rows and columns in the dataset.

How to move rows in Excel

The Excel spreadsheet by default moves or copies all data that it contains, including formulas and  resulting values, comments, cell formats, hidden cells, etc. Here’s how to move rows in excel:

  1. First select the row that you want to move
  2. Hold the Shift key on your keyboard
  3. Move your cursor to the edge of the row you want to move, follow the move icon on display (that is a four directional arrow icon)
  4. Left- click the edge of the row while still holding the Shift key
  5. Move it to the row where you want this row to be shifted using the drag and drop technique
  6. When you see a bold line right below the row you want to move to, leave the mouse button there(Keep holding the Shift key at the same time)
  7. Now leave the Shift-key and the row will move to its new location

If it is an entire row you are moving, select the entire row and then follow the same steps to move it.

How to move columns in Excel

Moving a column also follows the same steps. Here’s how to move columns in Excel:

  1. First select the column that you want to move
  2. Hold the Shift key on your keyboard
  3. Move your cursor to the edge of the column you want to move, follow the move icon on display (that is a four directional arrow icon)
  4. Left- click the edge of the column while still holding the Shift key.
  5. Move it to the column where you want this column to be shifted using the drag and drop technique
  6. When you see a bold line right below the column you want to move to, leave the mouse button there(Keep holding the Shift key)
  7. Now leave the Shift-key and the column will migrate to its new location

How to move or copy just the contents of a cell

  1. First double-click the cell that contains the data you want to move or copy
  2. Then select the row or column that you want to move or copy to
  3. Click the Cut or press Ctrl+X to move the cell. Command + X (Mac users)
  4. Or click Copy or press Ctrl+C to copy the cell.Command + C(Mac users)
  5. Click where you want to paste the characters in the cell, or double-click another cell to move or copy the data
  6. Then go to the Home tab, in the Clipboard group, click Paste or press Ctrl+V. Command + V(Mac users)
  7.  Then press ENTER

Tip: When you double-click a cell or press F2 to edit an active cell, the arrow keys will only work within that cell. To use the arrow keys to move to another cell, first press Enter to complete your editing changes to the active cell.

How to move rows in Excel without replacing existing data 

  1. Click on the row/column number to select the entire row or column that you want to move
  2. Place your cursor on the edge of the selected row till you see a 4-sided arrow cursor
  3. Press and hold the SHIFT key
  4. Then drag the selected row to another place
  5. The selected row will move to another place

Final thoughts

Follow these steps meticulously to be able to move rows, columns, cells in Excel sheet.

If you liked this tutorial, then kindly subscribe to our YouTube Channel for more Microsoft Excel video tutorials.

This article was first published on May 5 6:32 p.m. WAT

TAGGED:Excel TutorialHow to Excel
Share This Article
Facebook Reddit Threads Email Copy Link
ByOgechukwu Anthony
Editor-in-Chief
I am an experienced tech and innovation writer. It's been 3 years since I started writing at Terecle, covering mostly Consumer electronics and Productivity. In my spare time, I enjoy reading and learning the latest happenings around the tech ecosystem.

Latest

How to Become a Product Designer (2025 Beginner’s Guide)

By Ogechukwu Anthony
11 hours ago

21 Types of Software Engineers, their Roles and Skills

By Dara Eduok
1 month ago

How to Become a Software Engineer

By Ogechukwu Anthony
1 month ago

The Best VPN Chrome Extensions for Secure Browsing

By Ogechukwu Anthony
7 months ago

Related

How to Add a Total Row in Excel

How to Add a Total Row in Excel

By Ogechukwu Anthony
How to Change Tab Color in Excel

How to Change Tab Color in Excel

By Ogechukwu Anthony
How to Insert a Row in Excel

How to Insert a Row in Excel

By Ogechukwu Anthony
How to Remove Formatting in Excel

How to Remove Formatting in Excel

By Ogechukwu Anthony

Terecle is the #1 authority hub for career clarity and growth, guiding you from choosing your path to landing your dream job.

  • Editorial Statement
  • Privacy Policy
  • Cookie Disclosure
  • Advertise with us
  • Contact us

© 2021-2025 HAUYNE LLC., ALL RIGHTS RESERVED​

Terecle is part of Hauyne publishing family. The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of Terecle.