Need help in Excel 2016 [SOLVED]

[crispybagel]

Hi, i have a fairly simple question with maybe a not so easy answer (atleast i can't figure it out).

 

I have an excel document where i have collected data on different laptop models, CPU, GPU, RAM, weight, screen size, price etc. What i want to do is when i sort by a column, for example price or processor, i want a whole row to move together cause otherwise it would mess up the order of all the data.

 

I attached the Excel doc so you can view for yourself. 

 

Dator spreadsheet.xlsx

[Colexd]

doesnt it already do? i tried it

[unknownmiscreant]

3 minutes ago, Crispybagel said:

Hi, i have a fairly simple question with maybe a not so easy answer (atleast i can't figure it out).

 

I have an excel document where i have collected data on different laptop models, CPU, GPU, RAM, weight, screen size, price etc. What i want to do is when i sort by a column, for example price or processor, i want a whole row to move together cause otherwise it would mess up the order of all the data.

 

I attached the Excel doc so you can view for yourself. 

 

Dator spreadsheet.xlsx

Select the cells with data in them, click "data" on the ribbon, then "sort" (funnel icon), tick "my data has headers" then choose what to sort by, and ascending/descending, then ok.

[crispybagel]

2 minutes ago, Colexd said:

doesnt it already do? i tried it

lol, i was too scared to try it cause i didn't think it was going to work hahahahah and didn't want to mess up the data. god the humiliation....

[Colexd]

3 minutes ago, Crispybagel said:

lol, i was too scared to try it cause i didn't think it was going to work hahahahah and didn't want to mess up the data. god the humiliation....

its okay, we've all been there at some point lol