Expert Guide: Reorganizing Your Spreadsheet - Moving Cells Up or Down in MS Excel

Quick Links

If you’re looking to move a column or a row to a different location in your spreadsheet, you have multiple options to do that in Microsoft Excel. We’ll show you what those options are.

To use any of the below methods, first, open your spreadsheet with Microsoft Excel on your Windows or Mac computer.

How to Move a Column in Excel

To move a column in an Excel spreadsheet, use either drag and drop or the cut and paste method.

Move a Column With Drag and Drop

With Excel’s drag and drop method, you can move your columns around just by dragging and dropping them.

To use this method, first, find the column you want to move in your spreadsheet. At the top of this column, click the column letter so the entire column is selected.

Use your mouse or trackpad to bring the cursor to the border of the column. This turns your cursor into a four-arrow icon.

While your cursor is a four-arrow icon, press and hold the Shift key on your keyboard. Then drag the column to its new location in your spreadsheet. Excel will place your column to the left of the column where you drop it.

And that’ it. Your selected column is now available at its new location.

Click here

### Move a Column With Cut and Paste

Another way to move a column in your spreadsheet is by cutting and pasting the column.

To use this method, find the column you want to move in your spreadsheet. Right-click the letter at the top of this column and select “Cut” from the menu.

You’ll see an animated dotted line around your selected column. This confirms your column is successfully cut.

Find the column where you want to place your selected column. Excel will place your cut column to the left of this new column. Right-click the letter of this new column and select “Insert Cut Cells” from the menu.

Your original column will appear to the left of the selected column.

And that’s how you move around your columns in your Excel spreadsheets!

If you have data in one column that you want to be split into multiple columns , fixing that is easy!

PDF application, powered by AI-based OCR, for unified workflows with both digital and scanned documents.

How to Move a Row in Excel

Like with columns, you have a couple of ways to move rows in your spreadsheets. Use either drag and drop or cut and paste to move around your selected rows.

Move a Row With Drag and Drop

To quickly move a row to a new location, use this drag and drop method.

First, find the row to move in your spreadsheet. Then click that row’s number to the extreme left of your spreadsheet.

Hover your cursor over the selected row’s borders, and your cursor will turn into a four-arrow icon.

KoolReport Pro is an advanced solution for creating data reports and dashboards in PHP. Equipped with all extended packages , KoolReport Pro is able to connect to various datasources, perform advanced data analysis, construct stunning charts and graphs and export your beautiful work to PDF, Excel, JPG or other formats. Plus, it includes powerful built-in reports such as pivot report and drill-down report which will save your time in building ones.

It will help you to write dynamic data reports easily, to construct intuitive dashboards or to build a whole business intelligence cockpit.

KoolReport Pro package goes with Full Source Code, Royal Free, ONE (1) Year Priority Support, ONE (1) Year Free Upgrade and 30-Days Money Back Guarantee.

Developer License allows Single Developer to create Unlimited Reports, deploy on Unlimited Servers and able deliver the work to Unlimited Clients.

While your cursor is still a four-arrow icon, press and hold the Shift key on your keyboard. Then drag the row to its new location.

Your row is now placed at its new location.

WPS Office Premium ( File Recovery, Photo Scanning, Convert PDF)–Yearly

Move a Row With Cut and Paste

If you don’t prefer drag and drop, use the cut and paste method to move your rows.

First, in your spreadsheet, find the row to move. Then right-click this row’s number and select “Cut” from the menu.

Now find the row above which you want to place your cut row. Right-click this new row’s number and select “Insert Cut Cells” from the menu.

Your row is now at its new location.

And you’re all set.

There are times when you want to move your data around in your spreadsheets. With Excel’s quick and easy move options, you can quickly rearrange data in your various spreadsheets. Very useful!

And, if you ever need to turn a row into a column , Excel makes it equally easy to do that.

Win Able

Expert Guide: Reorganizing Your Spreadsheet - Moving Cells Up or Down in MS Excel