Jump to content

How to re-order excel column


Recommended Posts

Hey guys,

 

I have an excel worksheet with 50 columns, 2000 rows, how I can re-arrange them by column name? 

e.g. current column a,b,c

--> desired column a,c,b

 

how I can do it? Thank you so much!!

Link to post
Share on other sites
  • Moderators

@CC_Mu when you say "by name" are we to assume you have a column header? Or are you actually going to use the Column Letter (A1) format?

"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

Link to post
Share on other sites
On 5/2/2018 at 6:59 AM, JLogan3o13 said:

@CC_Mu when you say "by name" are we to assume you have a column header? Or are you actually going to use the Column Letter (A1) format?

I have a column header, like company, name, id, date etc

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...