Sort using 2 header rows

Kashi

New Member
Joined
Jun 22, 2006
Messages
3
My first row is a heading merged across columns. My second row contains headings for each column. Since it's a large spreadsheet it is inconvenient to select the data beginning at A2.

Is there a way I can designate two header rows and then sort?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,372
Office Version
  1. 365
Platform
  1. Windows
I don't think so.

If the problem in starting in A2 is that selecting the data is a pain (it is easy go past the end), why not just hit CTRL-END to go the end of the data, the select the range back up to A2? It is a little less of a nuisance to go "backwards" like this.
 

Kashi

New Member
Joined
Jun 22, 2006
Messages
3
Thanks. I hoping for another way. I guess I write to Micorsoft and ask them to add that feature to its next edition.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

Perhaps you could put your first-row-headings in cell-like textboxes.
Making row 1 higher there would be room for the headings of row 2 (which are now in row 1).

or
instead of merging you could use the "center accross selection" alignemt, but I don't think this would solve your problem

a good alternative could be a "double-click-sort" system
a doubleclick in any header in row 2 would trigger a sort: of course this would need some sheetevent-code

kind regards,
Erik
 

Forum statistics

Threads
1,136,877
Messages
5,678,290
Members
419,753
Latest member
Sallylwy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top