• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to move rows, move columns super fast in Excel

0 Comments

When working with Excel, you may need to rearrange the order and position of rows and columns. If you enter data incorrectly, you may want to reorder the position of those rows and columns. How can you do that? The article from Buffcom.net will guide you on how to move rows and columns quickly in Excel. Keep reading.

1. Moving columns in Excel

There are two ways to move columns in Excel: using the mouse or using keyboard shortcuts.

Method 1: Using the mouse to move

First, you need a data table like the one below.

First, you need to select the column you want to move. Hover your mouse over the beginning of the column, then click on the column name to select the entire column.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

Next, move your mouse to the new location where you want to move the column. To do this, you need to position the mouse where the mouse pointer becomes an arrow. Then click and hold the mouse, drag it to the new location, and release the mouse when the dotted border appears at the new location.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

When you are in the correct location, release the mouse button, and the column you selected will move to the new position. However, the column at the old position will be left blank, so you just need to delete it. To do this, select the entire column as described above. Then right-click on the selected range and choose Delete.

By looking at the image below, you will understand better.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

Method 2: Using keyboard shortcuts to move

With this method, you can use Excel’s Cut and Paste function to move columns.

First, you also need to select the entire column that you want to move. Then, right-click on the selected data range and choose Cut from the options.

First, you need to select the column you want to move, which is similar to the instructions above. Similarly, you can use the Ctrl + X shortcut to perform this action.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

Next, select the new location where you want to move the data to. Right-click on the selected range, and choose Insert Cut Cells from the options as shown in the image below:

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

The result is that the column is moved to the desired location.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

2. Moving rows in Excel

To move rows in Excel, you also perform similar steps as moving columns. We also have 2 methods to perform this.

Method 1: Using the mouse to move

First, select the row you want to move. Hover your mouse over the beginning of the row, then click on the row name to select the entire row.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

Next, move your mouse to the new location where you want to move the row. To do this, you need to position the mouse where the mouse pointer becomes an arrow. Then click and hold the mouse, drag it to the new location, and release the mouse when the dotted border appears at the new location.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

When you are in the correct location, release the mouse button, and the row you selected will move to the new position. However, the row at the old position will be left blank, so you just need to delete it. To do this, select the entire row as described above. Then right-click on the selected range and choose Delete.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

Method 2: Using keyboard shortcuts to move

With this method, please highlight the entire row that needs to be moved. Then, right-click on the highlighted range and select “Cut” from the dropdown menu. Alternatively, you can use the keyboard shortcut Ctrl + X to perform the action.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

Next, please highlight the position where you want to transfer the data. Then right-click on the highlighted range and select the “Insert Cut Cells” option from the dropdown menu as shown below:

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

The result on the screen is that the row that was highlighted will be moved to the position you have selected.

How to move rows, move columns super fast in Excel

How to move rows, move columns super fast in Excel

This article has introduced to you how to move rows and columns in Excel. We hope this article has provided useful information for you. Wish you success in implementing it!

Rate this post
39
294 Views
Instructions on How to Create and Remove Watermarks in Word A to ZPrevInstructions on How to Create and Remove Watermarks in Word A to ZMarch 3, 2023
How to search for data by row and column in ExcelMarch 3, 2023How to search for data by row and column in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
Products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Microsoft Visio Professional 2016 Key 1PC Microsoft Visio Professional 2016 Key 1PC $9.00
  • Microsoft Visio Professional 2013 Key 1PC Microsoft Visio Professional 2013 Key 1PC $9.00
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.69 out of 5
    $25.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

00Hours00Minutes00Seconds
Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.

BESbswyBESbswyBESbswyBESbswyBESbswyBESbswyBESbswyBESbswy