I am unable to edit cells in MS Excel 2007. When I click on a cell, a fuzzy border appears, followed by an error message (unable to enter). Even pressing the F2 key does not help. Not only can't I edit a cell, I can't save the file, close the file, or even quit Excel. It seems to freeze up. What gives?
First, I went to the office button on word 2007, went to Program Name Options, went to Word Options, click on Resources and then about. I had no product id in the field, so I contacted Microsoft. They had me verify my product key, then transferred me to another tech guy. I ended up un-installing all MS office products and then rebooted. He then sent me to a site where I downloaded a clean copy of office 2007. Once downloaded, I installed, opened MS word, and entered in my product key. I activated over the internet, closed the app, went back in, and then I was able to work in the application. Turns out that the product locked after 60 days and would not let me do anything until I had an activated product key. I hope this helps.
An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert who has answered 200 questions.
An expert whose answer got voted for 20 times.
Re: Unable to edit cells in MS Excel 2007...
When you open file click on is your file only readable then you will not be do anything. Find your EXCEL FILE IN BROWSER AND RIGHT CLICK AND THEN PROPERTY. NOW SEE IF YOUR FILE IS READ ONLY. IF YES THEN CHECK IT AND MAKE SURE IT IS NOT READ ONLY.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
you have to turn on the border. Highlight cells that you want to add the lines to, Right click on the highlighted cells, and select "Format Cells" Then choose the boarder tab. To only do horizontal lines, simply click on the top and bottom lines. This will turn the borders on, and then they will print.
1. Click Start. For Windows XP, click Run and then click in the Open box. For Windows Vista, click in the Start Search box. For Windows 7, click in the Search programs and files box. 2. Type appwiz.cpl and then click OK. 3. Select the Microsoft Office 2010 suite you want to repair and then click Change 4. Select Repair, and then click Continue. You may have to restart your computer after the repair is completed.
Select the cell(s) you would like the border around. Next right-click inside those cells and click "Format Cells." There will be a tab labeled "Border" which you can click on and all your options will be in there.
if you have excel 2007 you can save the file into excel 2003 compatibility
if you have excel 2003 need download compatibility pack from this page http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en install it and success!
In Excel 2007 click on Office button where File used to be, then click on Options at the bottom, then on Advanced at the left, then under Editing Options choose the option Enable fill handle and cell drag-and-drop.
Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now. Ctrl 1 to open the format cells dialog. On the protection tab uncheck locked. After you do this select the cell you want to lock. Ctrl 1 to open the format cells dialog. On the protection tab check locked.
You do not want to download the Free Outlook 2003 (any site offering free outlook 2003 is a scam/spyware filled) You can download Outlook free as a trial from Microsoft. Do not trust and Outlook or other Office software from any place besides Microsoft.. You want to download Microsoft Office 2007 Pro which is paid software. MS Outlook 2003 is not free. Go to Microsoft.com
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :
first change the settings in ControlPanel/Regional and Language Options. Click on Customize button/open the Date Tab and set the date format there. and then proceed with CSV. Open CSV in Excel and divide Text to coloumns. Ur all Date Cells will be in particual Format. and Select that coloumns and right click Format Celss....etc. Thanking u.
If u found any Douts, Suggestions ,Plzz let me know.
Simplest way is to highlight the area of cells you wish to work on, right click, select "format cells" , click on "borders" tab then you use the big buttons with symbols of either outside / inside / both, top/ bottom/ left/ right..then choose the line style, and select the colour from the palate, You can also use the "shading" tab to create interesting effects, as well as the "fonts" tab. you will learn more by experimenting...enjoy !