sort option is greyed out in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sort option is greyed out in excel 2000 premium edition. I am using windows
2000 pro and I have just formated my hard drive after my pc crashed. So I
installed everything from scratch.
Did I left something out? Do I have to install something else?
I just can't get the sort option to work.
I will really appreciate any help

Thank you
Gabriela
 
Hi Gabriela

check that the worksheet is not protected - tools / protection, and
unprotect sheet (if it is an option).

let us know if this solves the problem

Cheers
JulieD
 
Thank you Julie.
No, The workbook is not protected. I just create it.
.....???? I just can't figure it out LOL

Gabriela
 
Do you have more than one worksheet selected? The title bar would
display [Group] at the end of the workbook name.

If so, you can ungroup the sheets by right-clicking on one, and choosing
'Ungroup sheets'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Excel 2002 options grey out 2
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1
hyperlink option greyed out in excel 1
Excel Macros option greyed out 2
no cells, grey screen, all tabs greyed out 2
Sheet Tabs options greyed out 6
When excel is opened, Insert, Format, Data options greyed out. 2

Back
Top