Sort greyed out

T

trooperj3

New Member
Joined
Jan 8, 2010
Messages
20
I am having difficulty sorting out columns in my 2007 Excel spreadsheet.
The option to sort under the editing header is greyed out. If I right click on an individual column the option is there but it does not sort it correctly. The usual option asking if I wish to expand the selecetion also does not appear.
If I copy the spreadsheet and then paste it into a new sheet then the sort works fine.
Any help would be much appreciated.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Yes I selected the range to sort, in fact I usually always select the whole column and then am asked if I want to expand the selection.
Like I said previously, if I copy the whole spreadsheet and then paste it in a new sheet the sort works just fine,
 
Upvote 0
copy data in another sheet and delete the original sheet. see whether it helps.

while sorting preferably select the range of data only
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Group Auto Outline greyed out
Replies
1
Views
308
Ludwig
L
FrumpyJones
  • Question
Is it possible to do a multiple Filter-sort?
Replies
3
Views
118
Kaper
Kaper
E
  • Question
Does Excel have anything like Smartsheet's Hierarchy (Parent/Child rows)?
Replies
3
Views
448
Edgar_
Edgar_
V
  • Solved
Picture on CommandButton shows as grey rectangle when button is disabled
Replies
6
Views
326
VisualB
V
Keebler
  • Solved
clean code
5 6 7
Replies
66
Views
1K
Keebler
Keebler

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top