Overclock.net › Forums › Software, Programming and Coding › Other Software › Sorting in Excel and Windows Folder is different, how to fix?
New Posts  All Forums:Forum Nav:

Sorting in Excel and Windows Folder is different, how to fix?

post #1 of 5
Thread Starter 
I have files in folder sorted by name and list of same files in Excel also sorted, but it works different way. How I can change order in excel.
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
post #2 of 5
Click the "C" column so that the whole column is selected. Then go to the "Data" ribbon and click one of the sorting options in the middle of the ribbon.
post #3 of 5
Thread Starter 
C is sorted, problem that it does not sort same way as in folder. They both sorted from A to Z.
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
post #4 of 5
Thread Starter 
As you see in excel it sorts 100-109>10>110-199>19>1>200, as it should go 1>10>100
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
post #5 of 5
Thread Starter 
Found this thing, trying to understand what to do with it.

http://dmcritchie.mvps.org/excel/sorting.htm
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
 
HTPC / SERVER
(12 items)
 
 
CPUMotherboardGraphicsRAM
intel 4670k Gigabyte Z87X-UD3H MSI 750 Ti G.SKILL Ripjaws X Series 8GB 2133 
Hard DriveHard DriveCoolingOS
Samsung EVO 120Gb Seagate Barracuda 7200.12 500 Corsair h70 Windows 7 Pro 
MonitorKeyboardPowerCase
Asus VW266H 1920x1200 Logitech G-15 CORSAIR HX750 Antec 900 
Mouse
Logitech Performance MX 
CPUMotherboardGraphicsRAM
amd a10-7850k asus a88mx-a APU corsair vengeance 
Hard DriveCoolingOSMonitor
Corsair C300 stock Windows 7 Sharp 60" LCD 
KeyboardPowerCaseOther
Logitech K400r Corsair CX430M old temp Asus USB-AC53 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Sorting in Excel and Windows Folder is different, how to fix?