Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 170
Default XP EXCEL WORKSHEET WILL NOT SORT. HOW TO FIX

i am using a large worksheet which was transferred from access and am unable
to sort large portions of the worksheet. small parts seem to sort ok.

driving me nuts!!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default XP EXCEL WORKSHEET WILL NOT SORT. HOW TO FIX

I would first check to see that the data is contiguious, no empty rows or
columns within the area you wish to sort .....

Excel will not skip over the blanks by itself.

Vaya con Dios,
Chuck, CABGx3



"frank" wrote:

i am using a large worksheet which was transferred from access and am unable
to sort large portions of the worksheet. small parts seem to sort ok.

driving me nuts!!!

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
Excel 2002 Worksheet: Can I sort the columns ? Mr. Low Excel Discussion (Misc queries) 3 October 6th 07 12:44 AM
How to sort protected worksheet in Excel 07? Doesn't work. jbachaud Excel Worksheet Functions 1 June 1st 07 06:43 PM
sort excel worksheet Per Excel Worksheet Functions 6 March 12th 07 05:28 PM
Why can't I sort a worksheet in Excel? Littlegenie Excel Discussion (Misc queries) 3 December 15th 06 09:44 PM
How do I sort an excel worksheet with the if-then features? Carlyne Excel Worksheet Functions 2 December 28th 04 04:43 PM


All times are GMT +1. The time now is 02:08 PM.

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

About Us

"It's about Microsoft Excel"