Home > In Excel > Excel Won't Let Me Sort And Filter

Excel Won't Let Me Sort And Filter

Contents

It takes just 2 minutes to sign up (and it's free!). About Worksheet Protection Properties When you protect a sheet, Excel allows you to select from 15 different permissions you want to give to all viewers of the worksheet. You can allow users of the Due to this implementation of "Sort," this worksheet protection property does not work when the cells are locked. The solution may be to convert your table into a range or to expand your table to contain all of the data that you need to sort. check over here

In the "Allow Users to Edit Ranges" dialog: Click "Protect Sheet…" Give the worksheet a password Uncheck the worksheet protection property called "Select Locked Cells" Check the "Sort" property and the "AutoFilter" Apparently SPSS automatically groups the three sheets in the file. If you're having a computer problem, ask on our forum for advice. That would account for the behavior you describe.

Excel Won't Let Me Sort And Filter

However, the cell's official locked/unlocked status does not actually change. See this Microsoft Excel article  for more details about how to unlock ranges of cells. I cannot clear the Advanced filter setting, so have learned to work with it as I add rows. It may differ slightly or significantly with other versions or products. The sort feature was working correctly, as was the filter feature).

Solved my problem in less than a minute!! share|improve this answer answered Sep 12 '15 at 11:22 Amrit Shrestha 314 add a comment| up vote 0 down vote If you've reentered the data it is likely you've gotten rid clear any filter or sorting and try to reapply them. –Jook Nov 12 '12 at 17:05 Sorry Jook, how exactly do you reset borders? Clear Filter Excel Greyed Out And why on earth did Microsoft move everything around.

For instructions on attaching workbooks to posts, click here. If you want to allow only certain people to sort, give the range a password. What eventually did was to UNFREEZE PANES that I had previously frozen. Go through and find the empty rows and delete them and then try and sort again.

Then I made another column by summing up data in the first three columns. Excel Won't Sort Ian posted Dec 21, 2016 at 5:22 PM Brace yourself, The Steam Christmas Sale is coming. Click "OK" Step 2: Prevent users from editing these cells When protecting the worksheet, uncheck "Select Locked Cells" worksheet protection property. This will prevent users from editing the cells. The Anti-Santa: Dealing with the Naughty List more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology

Filter Option In Excel Not Working

Solution 2: Using Macros to Allow Locked Cell Sorting To use a Macro to allowed the sorting of locked cells, you will need to make a macro for every sort operation you would So on so on. Excel Won't Let Me Sort And Filter I had worried that in paying real money for real software after years of using freebies I had createsd a real problem. Can't Sort In Excel Because Of Merged Cells Please note that this range password is separate from the password you set to protect the sheet.

Screenshot here: i.imgur.com/QrPkd.png –D Windsor Nov 12 '12 at 16:59 check if there is any active cell-protection, select the whole rows 590-612 and try to reset their borders. http://webjak.net/in-excel/can-39-t-unhide-columns-in-excel.html Be sure to save your work prior to trying anything new! share|improve this answer answered May 10 at 21:09 James Meservy 1 add a comment| up vote -1 down vote In my case some of the formulas had references to the sheet share|improve this answer answered Jul 21 '15 at 14:27 Greg C 1 1 Hi Greg, this is not an answer. Excel Not Sorting Correctly Alphabetically

current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Enter your email address: .NET Blogroll Better Git with PowerShell Brij Hushan Leon Bambrick Mohamed Meligy Rob Conery Scott Guthrie BI Blogroll Andrew Brust Boyan Penev Chris Webb Richard Back Rob why do they give the same output? http://webjak.net/in-excel/excel-won-39-t-scroll-up-or-down.html This means when worksheet protection is turned off, a locked cell is no different from an unlocked cell.

Also, I cannot remove the borders on these 20 new rows. Excel Sort Largest To Smallest Not Working The answer ended up being that some of my cells in the sort column were entered as text, and some were vlookups from another page. Stay logged in Welcome to PC Review!

Browse other questions tagged excel sorting filter or ask your own question.

Any input is definitely appreciated. Dave24 Feb 2015, 18:08 Step 2 above "Select the Design tab of the ribbon." Design tab doesn't show up and yes I clicked into the data area. KannyKen06 Apr 2016, 09:29 Excellent tip. Excel Not Sorting Numbers Correctly share|improve this answer answered Apr 2 '15 at 18:42 jodafo 1 add a comment| up vote 0 down vote My data had been copied to a new worksheet, and then at

The time now is 03:37 AM. Just one additional note - the excel file with which I was working was created in SPSS. For example, using "Sort" does not just change the order of how the cells are viewed, it actually changes the values of the cells so that they are sorted. http://webjak.net/in-excel/can-39-t-unhide-row-1-in-excel.html Michael, Apr 24, 2008, in forum: Microsoft Excel Misc Replies: 5 Views: 1,580 Gord Dibben Apr 25, 2008 Why can't I sort a 2003 file in 2007? 2007 freezes.

microsoft-excel sorting share|improve this question edited Nov 28 '12 at 18:52 Synetech 51.2k25148280 asked Nov 28 '12 at 18:13 Jane Vazquez 19112 2 We'd need to see the data to That's it; if you can now add information and sort your data, then the problem is solved.