Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Auto-Sort Won't Sort All Column Cells

Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The
spreadsheet has several columns which sort easily, but the last column will
only sort a select tiny block of cells. Is there a way to correct this so the
Auto-Sort will sort the entire column? Many thanks!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Auto-Sort Won't Sort All Column Cells

Check for blank rows or columns (hidden rows and columns too)

Also, look at your column headers. Does the last column have a column
header that uses the same formatting as the other columns?

What about Data - Sort and trying it from there?



"TikiTembo" wrote:

Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The
spreadsheet has several columns which sort easily, but the last column will
only sort a select tiny block of cells. Is there a way to correct this so the
Auto-Sort will sort the entire column? Many thanks!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to Auto sort or save a sort? Barbie Excel Discussion (Misc queries) 11 December 1st 09 10:48 PM
How can I set up Excel to auto-sort each column independently? davisjw Excel Worksheet Functions 2 March 17th 08 12:21 PM
Auto data sort by clicking on column Jack C Excel Discussion (Misc queries) 2 August 29th 07 01:02 PM
Dynamic column chart - auto sort on data range jimfrog Charts and Charting in Excel 0 March 29th 06 02:45 PM
How to AUTO SORT A-Z new data in a column (not menual sorting) Nir Excel Worksheet Functions 2 November 8th 05 11:29 PM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"