Thứ Ba, Tháng Tám 9, 2022
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
NATuts
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
No Result
View All Result
NATuts
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
No Result
View All Result
NATuts
No Result
View All Result
Home Tech

How to move columns in Excel (3 simple exchange methods)

7 Tháng Mười Hai, 2021
in Tech
0
How to move columns in Excel (3 simple exchange methods)
585
SHARES
3.3k
VIEWS
Share on FacebookShare on Twitter

Sometimes in order to view and compare data more intuitively, we need to move the position of the column. You can use multiple methods for one or more columns.

Microsoft Excel is one of the best software that can be used to arrange values ​​or words in a table. Sometimes, you may want to compare and contrast certain data in different columns. The value of the worksheet may be too great, and you may be confused when evaluating the form as it is.

Here are some ways you can move columns in “Ladies”. Excel is effortless.


1. Copy and paste method

In this case, you need to copy and paste one or more columns.

step 1: To move a column, click the English letter at the top to select the entire column.

Click the English letter at the top

Step 2: Second, use the keyboard shortcut (Ctrl + C) to copy.

Copy using keyboard shortcuts

Step 3: You now need to copy the content to the new column. Therefore, click on your target letter position, such as “C”. Use the keyboard shortcut (CTRL + V) to paste the “copied column” into a blank column.

the fourth step: You can now delete the original column. Click on a letter like “A”, right-click, and select Delete from the drop-down list.

You can now delete the original column


2. Drag the column

You can also use the drag method to move columns in Excel.

step 1: Click the letter above the target column. If you want to move column A, move the mouse to column A.

Click the letter above the target column

Step 2: Before clicking, the mouse pointer will turn into a black downward arrow. Therefore, click once to select the entire column.

Step 3: Then, move the mouse to the boundary of the column. When a black four-way arrow appears, hold down the shift key.

the fourth step: At this time, you can drag the left mouse button to move the column left and right. This will move the column to another space. For example, from A to E.

  • hint: If you want to move multiple columns, you can hold down the Ctrl key to make multiple selections.

3. Sort all columns

This is the adjustment method for large watches. This method is very effective if you have to reposition many columns in the table. This method is faster!

step 1: First, create a new blank row at the top. You can do this on line 1. Move the cursor to 1; a black arrow will appear.

Các bài viết liên quan:

Download 3DVista Virtual Tour 2019

Download 3DVista Virtual Tour 2019

8 Tháng Tám, 2022
Nha Trang Stone Bridge Port

Nha Trang Stone Bridge Port

8 Tháng Tám, 2022
Taiwan is about to rehearse the anti-occupation of the island

Taiwan is about to rehearse the anti-occupation of the island

8 Tháng Tám, 2022
Instructions for using SMS OTP V3 spam tool

Instructions for using SMS OTP V3 spam tool

8 Tháng Tám, 2022
How to Do Venmo Identity Verification [2022 Guide]

How to Do Venmo Identity Verification [2022 Guide]

8 Tháng Tám, 2022
Meta disrupts cyber espionage in South Asia Facebook abuse

Meta disrupts cyber espionage in South Asia Facebook abuse

8 Tháng Tám, 2022

Step 2: Click on row 1 to highlight the entire row.

Click on row 1 to highlight

Step 3: When the first row is highlighted, right-click the pop-up menu and select “Insert”. A new row will be created at the top.

Right click on the pop-up menu

insert

the fourth step: You can now adjust the order of the columns as needed. Then enter the numbers according to your preferences.

Step 5: Next, you need to select all the columns to sort them. , Left-click on the farthest column at the top, and then move the mouse to the lowest column at the bottom.

You need to select all columns

Step 6: After selecting all the columns, on the top menu bar, click “Data”> “Sort”. A dialog window will appear. Modify it according to your needs.

After selecting all the columns, in the top menu bar

Step 7: You can change the order to arrange values ​​from smallest to largest, largest to smallest, value, cell color, font color, cell icon, or individual columns. When you are done, remember to click “OK” to apply the changes.

You can change the order

Now your values ​​will be sorted according to the specific sorting method. You can also do this for words and sort them according to the alphabet.


Use Microsoft Excel to move columns easily.

You can also use the same method to move rows. The ultimate goal of adjusting the table is to make it more concise and understandable. This will make it easier for others to get valuable things from your data.

These new tips and tricks will help you save enough time when working with Excel worksheets. Make your presentation easy to understand!

Previous Post

Pictures of sad, lonely flowers

Next Post

Billionaire returns $70 million worth of stolen antiques

Admin Natuts

Admin Natuts

Related Posts

Instructions for using SMS OTP V3 spam tool

Instructions for using SMS OTP V3 spam tool

8 Tháng Tám, 2022
How to Do Venmo Identity Verification [2022 Guide]

How to Do Venmo Identity Verification [2022 Guide]

8 Tháng Tám, 2022
Meta disrupts cyber espionage in South Asia Facebook abuse

Meta disrupts cyber espionage in South Asia Facebook abuse

8 Tháng Tám, 2022
Instructions to install Outline VPN on Ubuntu

Instructions to install Outline VPN on Ubuntu

7 Tháng Tám, 2022
What is Conhost.exe and why is it running on my computer

What is Conhost.exe and why is it running on my computer

7 Tháng Tám, 2022
How to make the background transparent in Canva

How to make the background transparent in Canva

7 Tháng Tám, 2022
Load More
Next Post
Billionaire returns $70 million worth of stolen antiques

Billionaire returns $70 million worth of stolen antiques

Trả lời Hủy

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Bài viết mới

Download 3DVista Virtual Tour 2019
Software

Download 3DVista Virtual Tour 2019

8 Tháng Tám, 2022
Nha Trang Stone Bridge Port
Travel

Nha Trang Stone Bridge Port

8 Tháng Tám, 2022
Taiwan is about to rehearse the anti-occupation of the island
News

Taiwan is about to rehearse the anti-occupation of the island

8 Tháng Tám, 2022
Instructions for using SMS OTP V3 spam tool
Tech

Instructions for using SMS OTP V3 spam tool

8 Tháng Tám, 2022
How to Do Venmo Identity Verification [2022 Guide]
Tech

How to Do Venmo Identity Verification [2022 Guide]

8 Tháng Tám, 2022
Meta disrupts cyber espionage in South Asia Facebook abuse
Tech

Meta disrupts cyber espionage in South Asia Facebook abuse

8 Tháng Tám, 2022
W3Schools

Ads

Contact: [email protected]

DMCA.com Protection Status

Categories

  • Android
  • Cạm bẫy tâm lí
  • Chưa được phân loại
  • Đồ họa
  • Đời sống
  • Gen Z
  • Health
  • iOS
  • Kĩ năng mềm
  • News
  • Nhà mạng
  • Phần mềm
  • Phần mềm đồ họa
  • Review sách
  • Software
  • Tech
  • Thiết kế ảnh
  • Thiết kế video
  • Thủ thuật
  • Travel
  • Văn hóa Nam Bộ
  • Văn học
  • Window

Browse by Tag

ai là triệu phú android Apple browser Bullet Journal bản thân Chỉnh ảnh data domain download du lịch fshare game game show hosting HÌNH XĂM IKEA ios khuyến mãi kinh doanh kiến thức kiểm tra pin lừa đảo messenger miễn phí mua sắm Máy ảnh mạng mồi tiềm thức network nghệ thuật nhà Trần quảng cáo review tháp phân tầng xã hội tiếng anh tiện ích Trần Thủ Độ tên miền từ vựng viettel word xã hội Đơn giản đánh bạc

Recent News

Download 3DVista Virtual Tour 2019

Download 3DVista Virtual Tour 2019

8 Tháng Tám, 2022
Nha Trang Stone Bridge Port

Nha Trang Stone Bridge Port

8 Tháng Tám, 2022

Trang tin nóng hổi - vừa thổi vừa xem

No Result
View All Result
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z

Trang tin nóng hổi - vừa thổi vừa xem