grouping cells and sorting

R

rgilles

I have set-up an excel spreadsheet that encompasses several lines tha
are all related to each other so when I sort the worksheet I want t
keep those groups together. For instance if the spreadsheet liste
vehicles line 1 would be the make and model and line 2-5 would lis
options on this vehicle. Is it possible to sort the page keeping th
options with the vehicle
 
G

Gord Dibben

Not possible without some modification.

Assuming Column A holds Vehicle

Select Column A and Edit>Go To>Special>Blanks and OK

In Active Cell type = sign then mouse-point and click on cell above.

Hit CRTL + Enter.

The Vehicle will be repeated down column A and change at each new Vehicle.

You can copy Column A and(in place) Paste Special>Values>OK>Esc.

Select all columns and sort on column A.

Gord Dibben Excel MVP
 
Top