Menu
Excel for Mac Sorting Problems Hey When I highlight an area that I want to be sorted, let's say rows 20-40 in columns AB-AD, I go to Data-Sort and it instead highlights every column before it for sorting, so rows 20-40 from columns A-AD. Last updated: November, 2018. Excel for Mac crashes and slow performance. [FIXED] Scrolling between cells in Excel 2016 for Mac is slow. Excel for Mac.
Hello, I have a problem using Excel data sort & filter. I have an Excel file close to 500 lines. This is a phone directroy: Column A is for area code Column B is for phone extension (4 digits) Column I is for the user Last Name Column J is for the user First Name When I sort the file with First Name or Last Name everything seems to work well. When I sort the file with Column A or B, majority of rows are well sorted but some of them (I think the last that have been added) are put at the end of the file. Is there someone that can explain or have a similar problem? Kind regards. Yes, access can do this.with make table queries load the spreadsheet/table into access.
![Custom sorting in excel Custom sorting in excel](/uploads/1/2/5/4/125498418/662633461.jpg)
Query: in 'Totals' function Call in theĀ fields that you want. You can't. it because of the calculatation.so you have to bring them all in individually Ensure you call in the sys generated 'ID' fields for 'ID' Total is 'Where' and the criteria is A and B. Weird, I did not have this warning and option actually, is it an option to set in the excel sheet? Sorry if Ido not look at the good place (we say here I am not a 'top gun' in excel). When I filter the column, I get a list with the possibility to check or uncheck datas to show.
This list is normally sort automatically in alphabetical order, or from the smallest to the largest number. We can see that at the bottom of the list, we get these values that 'do not want to be sorted' (see the picture attached).
The Librarian wrote: That is because you are using a filter rather than actually sorting the sheet. To Sort.
Select the entire sheet. Click on the 'Data' tab then 'Sort'. Select the column on which you wish to sort (Exten.).
Click OK. Then you will see the choice mentioned in my previous post.
Make sure you select all the columns. Otherwise you could end up changing the order of some but not others which will scramble your data. The Librarian solved my problem. To make my filter work (to sort by smallest to largest), I had first to reorder all the sheet as The librarian told in his post.
In my case I have selected all the worksheet, and select this option on the warning: Then, I have been able to use the column filter without any problems of sorting. Thanks to everybody that has answered and help to resolve this!