Ask Mac Questions and Get Answers from Experts ASAP
I know the following suggestion may be trivial but it is the first thing you should check in such a case
On the menu bar click Windows > Freeze Pane > Unfreeze Pane. Also make sure that the sheet is not protected
Hope this helps. Let me know if you have any questions
If the file has sensitive information let me know before you upload it
You said the Freeze option is grayed out. Surely this is not the case with other files or New files
Ok will check and get back to you
Ok make sure that your spreadsheet is in Normal view (under View > Normal)
Let me know
Yes most likely it is. The page layout is the not the standard spreadsheet mode and it has a lot of limitations
Hope that helped. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the assistance as this is the only way I get credit for my time
You said: "..I could not enter data in a particular field ...", so in addition to having problems in your Excel application (crashing) and other problems with your system you also appear to have problems with that particular file. I would like to have a look at the file and inspect that particular field. Please send me that file so I can continue assisting you
I got the file, thanks
Ok which cell is the field that you could not enter data in?
Uninstall your Office application (provided you have the CD and product key) then create a new user profile, reboot and login to the new profile, then re-install Excel from that profile. This should start you fresh without having to reinstall the Mac OS
Jerry, I am not sure why you have 2 CD's. You should know what and how you purchased. However I would use the most recently acquired CD. If in doubt, place the one that says Office:mac... and wait until the setup utility gets launched then follow the prompts until installation it completes the installation.