Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Len Melcer
 
Posts: n/a
Default How do I unhide the cell format function in Excel 2000

I have a spreadsheet where the cells with data entered in them can have the
Format Cell option selected but any empty cells cannot have the Format Cell
option selected. I can enter text but am unable to format the cell afterwards.
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
any chance this sheet is protected?

--
Regards
Frank Kabel
Frankfurt, Germany

Len Melcer wrote:
I have a spreadsheet where the cells with data entered in them can
have the Format Cell option selected but any empty cells cannot have
the Format Cell option selected. I can enter text but am unable to
format the cell afterwards.



  #3   Report Post  
Len Melcer
 
Posts: n/a
Default

Not in any obvious way. The Tools-Protection option appears to show the
sheet and workbook as unprotected.

"Frank Kabel" wrote:

Hi
any chance this sheet is protected?

--
Regards
Frank Kabel
Frankfurt, Germany

Len Melcer wrote:
I have a spreadsheet where the cells with data entered in them can
have the Format Cell option selected but any empty cells cannot have
the Format Cell option selected. I can enter text but am unable to
format the cell afterwards.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy Excel Worksheet Functions 7 December 11th 04 08:53 PM
Writing many lines on a same Excel 2000 cell freeposte Excel Discussion (Misc queries) 2 December 8th 04 02:45 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"