Sorting on Column headers

  • Thread starter Thread starter hubs
  • Start date Start date
H

hubs

I have a spreedsheet that someone else created and I need to take the
Column headers, which are in date form, and rearrange them in
chronological order. Can this be done without cutting and pasting? I
really need to save time with this project if possible.

Thanks!:)
 
I have a spreedsheet that someone else created and I need to take the
Column headers, which are in date form, and rearrange them in
chronological order. Can this be done without cutting and pasting? I
really need to save time with this project if possible.
Click to expand...

Yes, use the transpose feature in Edit > Paste Special then sort the items
then transpose them back.
 
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

sorting columns sorts header values too 6
Auto-sort worksheet by date in column A 3
arranging dates in chronological order 3
Locking column headers 1
Sorting by Column Headers 2
Header in row to column 1
Sort data in rows to column 1
How can I save a sort order for re-use instead of having to type i 1

Back
Top