Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2013, 09:24 AM
texascpa texascpa is offline EXCEL will not sort Windows XP EXCEL will not sort Office 2010 64bit
Novice
EXCEL will not sort
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default EXCEL will not sort

I have spread sheet with 10 Columns. One column (B) is formatted as numerical. All other fields are combination of numerical and text.

When I highlight the spreadsheet and try to sort the numerical column B, nothing happens.

What is causing the spreadsheet not to sort?
Reply With Quote
  #2  
Old 04-16-2013, 03:21 AM
OTPM OTPM is offline EXCEL will not sort Windows 7 32bit EXCEL will not sort Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Without seeing a copy of your spreadsheet it is difficult to diagnose. If there is nothing sensitive in it then can you post a copy so we can take a look.
Tony
Reply With Quote
  #3  
Old 04-16-2013, 07:56 AM
texascpa texascpa is offline EXCEL will not sort Windows XP EXCEL will not sort Office 2010 64bit
Novice
EXCEL will not sort
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default

https://dl.dropboxusercontent.com/u/...st%20File.xlsx

Thanks for your help. The above is a link to the spreadsheet. Trying to sort the last column. High to low or low to high---does not matter.
Reply With Quote
  #4  
Old 04-17-2013, 01:25 AM
OTPM OTPM is offline EXCEL will not sort Windows 7 32bit EXCEL will not sort Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Thanks for sending the link to your spreadsheet.
The reason you cannot sort the data is because you already have three consolidations to your data.
Hope this helps.
Tony
Reply With Quote
  #5  
Old 04-17-2013, 07:16 AM
texascpa texascpa is offline EXCEL will not sort Windows XP EXCEL will not sort Office 2010 64bit
Novice
EXCEL will not sort
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default

Tony: So all I need to do is copy the information to a new spread sheet. Correct?

jerry
Reply With Quote
  #6  
Old 04-17-2013, 07:56 AM
OTPM OTPM is offline EXCEL will not sort Windows 7 32bit EXCEL will not sort Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Jerry
On the left hand side of your worksheet you have 3 columns separate to the worksheet which appear to be some form of Consolidation.
This is why you are unable to use the normal sorting on ANY of the columns in your worksheet.
If you don't need the Consolidation then copy your data to a new sheet and you will be able to sort as you wish.
Hope this helps.
Good luck.
Tony
Reply With Quote
  #7  
Old 04-17-2013, 07:58 AM
texascpa texascpa is offline EXCEL will not sort Windows XP EXCEL will not sort Office 2010 64bit
Novice
EXCEL will not sort
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default

Tony:

Thanks for your help!
Reply With Quote
Reply

Tags
sorting



Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL will not sort Simple Excel sort did not work correctly Spideriffic Excel 1 09-06-2012 04:40 AM
sort data in excel cabot Excel 1 08-17-2012 09:41 AM
EXCEL will not sort Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Excel sort problem jaz Excel 2 01-16-2011 04:24 AM
Sort Macros boutells Excel 1 07-16-2009 11:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft