What method should i use to arrange the rows based on the year i placed?

F5F Stay Refreshed Software General Software What method should i use to arrange the rows based on the year i placed?

What method should i use to arrange the rows based on the year i placed?

What method should i use to arrange the rows based on the year i placed?

H

Hanshb3
Member

132

08-12-2021, 05:48 PM

#1

Refer to the example. I want to arrange the rows based on the year I enter... how can I do that? I made a mistake in the selection. The top-most YEAR is a label and shouldn't be sorted.

H

Hanshb3

08-12-2021, 05:48 PM #1

Refer to the example. I want to arrange the rows based on the year I enter... how can I do that? I made a mistake in the selection. The top-most YEAR is a label and shouldn't be sorted.

I

ironfroggy
Member

54

08-14-2021, 07:08 AM

#2

This guide shows how to maintain row alignment while sorting in Excel and Google Sheets. It explains the process of keeping rows together during a sort, similar to what you'd see in LibreOffice.

I

ironfroggy

08-14-2021, 07:08 AM #2

This guide shows how to maintain row alignment while sorting in Excel and Google Sheets. It explains the process of keeping rows together during a sort, similar to what you'd see in LibreOffice.

S

saintecraft
Junior Member

28

08-14-2021, 07:35 AM

#3

Please upload another image and indicate the area you wish to sort.

S

saintecraft

08-14-2021, 07:35 AM #3

Please upload another image and indicate the area you wish to sort.

E

Eggrole
Member

62

08-14-2021, 09:14 AM

#4

sort and filter handle the task well, but you're experiencing an issue.

E

Eggrole

08-14-2021, 09:14 AM #4

sort and filter handle the task well, but you're experiencing an issue.

A

Ametera
Member

62

08-14-2021, 05:39 PM

#5

don't worry about columns on the left or right, i just need to rearrange the rows so that the oldest year appears first, like 2014.

A

Ametera

08-14-2021, 05:39 PM #5

don't worry about columns on the left or right, i just need to rearrange the rows so that the oldest year appears first, like 2014.

A

avi15
Member

167

08-15-2021, 12:49 AM

#6

Only the blue rectangle needs to be sorted.

Is this a genuine Excel file or a LibreOffice document?

A

avi15

08-15-2021, 12:49 AM #6

Only the blue rectangle needs to be sorted.

Is this a genuine Excel file or a LibreOffice document?

T

Takeo_Player
Member

177

08-15-2021, 04:09 AM

#7

This guide shows how to maintain row alignment while sorting in Excel and Google Sheets. It explains the process of keeping rows together during a sort, similar to what you'd see in LibreOffice.

T

Takeo_Player

08-15-2021, 04:09 AM #7

This guide shows how to maintain row alignment while sorting in Excel and Google Sheets. It explains the process of keeping rows together during a sort, similar to what you'd see in LibreOffice.

C

Cra123
Senior Member

251

08-15-2021, 12:40 PM

#8

items on either side are shifted together, items in a specific row remain unaffected. It's openoffice

C

Cra123

08-15-2021, 12:40 PM #8

items on either side are shifted together, items in a specific row remain unaffected. It's openoffice

X

xDread_Lordx
Junior Member

15

08-23-2021, 12:52 AM

#9

You need to choose the relevant data points to sort. Then you will see a prompt.

X

xDread_Lordx

08-23-2021, 12:52 AM #9

You need to choose the relevant data points to sort. Then you will see a prompt.