format cells option not working

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

when i highlight some cells and try to format them nothing happends,
workbook and sheets are not protected, cells in question dot not have any
data in them at all, totaly blank!

if they are locked how can i findout? and how to unlock them?

Thanks,
Steve
 
If there's no data in them, I don't know how you can tell that the format is
not occurring. Anyway, to find out if a cell is locked, just try to change
the value. If you can, it's not locked.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
ok I can enter data in the cells, but when I alt click and pick format cells
nothing happens.

-Steve
 
So, Ron de Bruin's answer doesn't help either? Does it happen only in this
file? Is the worksheet or workbook protected? If it happens in all files,
then I can only suggest troubleshooting Excel:
www.theofficeexperts.com/excel.htm
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
ok, today when i opened the file i was asked if i wanted to update, now i
can format the cells.

stange thing is though iv not been here until now, so no data has been
changed.

Thanks for you help Anne & Ron,
-Steve
 
Back
Top