ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   XP EXCEL WORKSHEET WILL NOT SORT. HOW TO FIX (https://www.excelbanter.com/excel-worksheet-functions/166963-xp-excel-worksheet-will-not-sort-how-fix.html)

Frank

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!!!

CLR

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!!!



All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com