How do I insert multiple columns across rows in Excel?

Source: Internet
Author: User
Tags sort

How do I insert multiple columns in Excel in rows? Inserting multiple rows into rows in Excel is also common, so how do we do that? Let's learn.


Open the Excel file and find the contents of the table to which you want to insert multiple columns.

First insert a row above the name, right-insert-whole line.

Then insert the Line table, enter 1-6 in order, and then copy and paste one line later.

Select all content, find the sort in the beginning, and customize the sort.

In the custom sort that appears, option selection is sorted by row, OK.

The main keyword is to select row 3, ascending, OK.

The inserted row is then deleted and a column is inserted between the columns.

The above is how to insert multiple columns in Excel introduction, the operation is very simple, we have learned? I hope this article can help!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off,Oct.24-Nov.13 (UTC+8)

Get It Now >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.