Sheet presentation: puting column in order

  • Thread starter Thread starter ccd
  • Start date Start date
C

ccd

I get an Excel sheet with many columns. I would like to set them quicly
in a given order. I have column headers.
Today a use cut/paste. But it is long !
Is there any possibility to see the column header and associate those a
column number ?
 
Type column numbers you want in an empty row at the top and us
Data/sort
 
Note you need to hit the Options button on the Sort dialog box and choose left
to right (And make sure you select ALL the data to be sorted). Be very sure you
have got it right before you save again, as there will be no going back if you
haven't.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Columns based on Header name 1
Figuring out a lengthy formula. Probably quite simple... 3
Need to separate column data into headers 5
Count the columns from one sheet and paste it in another sheet 0
Get Columns 3
How to list cells from two sheets that has different values in theirneighboring column? 8
Single column to multiple columns 5
Copy of value from one sheet to another with matching column values 1

Back
Top