Tuesday, September 27, 2022

How to Easily Move Columns in Excel

Excel is straightforward to use, but sometimes there may be problems for newbies on how to move columns in Excel. However, there are several ways to rearrange your columns in an Excel worksheet. 

How to Move Columns in Excel Using Mouse

Here’s how to move columns in Excel using your mouse. Getting this done only takes a highlight and a drag-and-drop motion.

  • Place the cursor over the top of the column you want to move in the worksheet you want to rearrange.
  • Your cursor change to an arrow immediately. Now click to highlight the columns once you’ve noticed the changes.
  • Now, press and hold the Shift key on the keyboard.
  • And then click and hold on the right or left border of the column you want to move and drag it to the right or left.
  • As you drag your cursor across the columns, you’ll see the borders darken to indicate where the new column will appear.
  • When you’re happy with the location, release the mouse click.

Using Cut And Paste 

  • Select the entire column by clicking on the column header.
  • Use the Ctrl + X, or right-click the column and choose Cut from the context menu to cut the selected part.
  • Select a column to insert your already cut columns.
  • Now, click on it and choose Insert Cut Cells from the pop-up menu.

Editor’s pick:

Diekola Jubril
Diekola Jubril
Passionate for gaming and exploring nature, I face every task as a new challenge to bring my skills to the next level.

Related Articles

Stay Connected

3,280FansLike
48FollowersFollow
45,629SubscribersSubscribe

Latest Articles

My Six Criteria For Choosing a Software to Base Your Business On

Choosing the best factory software that fits the company's needs, of course, has its own challenges. Because there are many aspects that you must...

Editor's Picks

9 Best Laptops for Engineering Students in 2022

Students searching for the best laptops for engineering need a lot of power. But they need a few other things as well. Most matriculating...

6 Best Business Laptops You Can Buy in 2022

Whether you're buying a fleet of laptops for your employees or just looking for a productivity system, you'll want one of the best business...

Top 12 Best Gaming Laptops for 2022

Purists will argue that you need a PC to play games, especially if you're a fan of pushing the levels of graphics quality beyond...

Top 12 Best Gaming PC in 2022

Only the best gaming PCs will let you get the most out of the best PC games. Despite the allure and simplicity of gaming...

Best 85-inch TVs Money Can Buy in 2022

Nothing is as impressive as a really big TV, especially true of the best 85-inch TVs. So whether you want to feel like you're...