Microsoft Excel for PC Logo
Posted on Jan 30, 2011
Answered

Today using Excel 2007, I tried editing an existing document that I'd imported from another computer. All functions were grayed out, and no text could be typed nor any cells edited. So I tried with a new spreadsheet. The functions and buttons work, but I cannot type in any cells, nor paste. Help? -Josh

Answer This Question

1 Answer

Zenka Sabala

Zenka Sabala

Level 1:

An expert who has achieved level 1.
MVP:

An expert that got 5 achievements.
New Friend:

An expert that has 1 follower.
Greenhorn:

A rookie expert who has answered 20 questions on their first day.

  • Contributor 22 Answers
  • Posted on Oct 23, 2013
Zenka Sabala
Contributor
Level 1:

An expert who has achieved level 1.
MVP:

An expert that got 5 achievements.
New Friend:

An expert that has 1 follower.
Greenhorn:

A rookie expert who has answered 20 questions on their first day.

Joined: Oct 23, 2013
Answers
22
Questions
0
Helped
2808
Points
23

The sheets might be protected. To remove the protection, go to the "Review" tab, in the Changes group click on "Unprotect Sheet"

5 Related Answers

Anonymous

  • 143 Answers
  • Posted on May 23, 2008

SOURCE: how to protect a single cell in excel from modification

Found on the internet and it seems to work:

The default setting for each cell is for them to start locked. So, you first need to highlight ALL cells in the sheet, right click, choose format, go to the Protection tab and take the tick out of the Locked box.

Now no cells are locked.

Now you need to select the one cell you want locking. Right click, choose format cells, Protection tab and then put a tick into the Locked box.

Locking the cells does not take place until you have locked the sheet. So go to Tools, Protection and Protect Sheet. Add a password of your choosing, and put a tick into every option available to you, EXCEPT the very top option. "Select locked cells" should NOT have a tick in it.

OK that to confirm, and hey presto, that cell can no longer be selected, edited or erased unless you unprotect the sheet by entering the password you chose.

Ad

Anonymous

  • 48 Answers
  • Posted on Apr 13, 2009

SOURCE: text in excel textbox turns to gibberish

It may be a font issue... did you change the font of the typed-in text to a non-True Type face? For every typeface there are two fonts: a screen font to display on your monitor and a printer font for printing,

If somehow there is confusion or corruption in the Excel file contents about exactly which font is specified at a given point in the text box (e.g.if you type like I do with lots of backspaces, which are actually special codes that can cause such corruption), then the misfire between screen and print fonts can cause the text data to be corrupt. It seems to be an operating system issue (did you make a lot of changes to fonts on your system?) or something wrong with your personal installation of Office 2003 in any case, because Excel 2003 is a very stable release. To fix this I would try examining the Windows\Fonts folder using a third-party tool or comparing its contents to a known-good Windows installation (or simply copy and paste your typed paragraphs into Notepad and re-paste it into a new text box in a New Document (starting fresh with a new Excel worksheet could solve it all by itself).

Anonymous

  • 156 Answers
  • Posted on May 23, 2009

SOURCE: Code not working

CLICK THE LINK BELOW AND DOWNLOAD OFFICE, ANY VERSION WHICH U LIKE

http://us1.trymicrosoftoffice.com/default.aspx

AND HERE ARE THE ACTIVATION KEYS

Microsoft Office 2007 Professional

XC84W-M642D-2QDWY-YTKMM-RWJQW OR TCCMP-PXGHB-3TR88-6WDCX-2HDBD

OR H36BT-QFYMQ-FCFC3-KYQ69-G67PT

Microsoft Office Professional 2007
T3PVR-XX42X-T49DW-WGBG6-9FT73 OR C3T4B-8MD24-46K4H-6XPPX-VD6YD

OR DM6GQ-HM9CG-HCVY9-T3C74-GVHVW

MS Office(Home and Student) 2007: GHJGD-TWT9Y-G7H42-FWDJK-3G6KW

MS Office(Home and Student) 2007: KRBWK-TVGBX-3KQG4-H7WXG-KQGKM

Microsoft Office Home & Student 2007: JWR9T-HFR92-74RQ7-3FRMB-CY676

Norton Antivirus 2008:VGH96-FY8HM-443GH-F4Y36-PYH98

Microsoft Office Home & Student 2007: TW6JJ-D28JW-B7KRM-44W66-MGVGY

Microsoft Office 2007 Home and Student: B4MKP-KP9YP-7TBQ4-7T4XF-MTGWY

Microsoft Office 2007 Home and Student: DDY79-433JV-2RXGX-MQFQP-PFDH8

Microsoft Office 2007 Home and Student: DDY79-433JV-2RXGX-MQFQP-PFDH8

Microsoft Office Home and Student 2007: DDY79-433JV-2RXGX-MQFQP-PFDH8

Microsoft Office Home and Student 2007: B4MKP-KP9YP-7TBQ4-7T4XF-MTGWY

Microsoft Office Home and Student 2007: KGFVY-7733B-8WCK9-KTG64-BC7D8


Microsoft Office Small Business 2007: S/N: CKMPB-6B4QT-MG4C6-2VH4C-RDD43 Or HTPWX-FR6J8-2WBCQ-T63JR-3M8PD

A Few Activation Keys for Office 2007 Home and Student.
More on the Way for different MS Products
Visit us at thedeadlyghost dot com.
before visit this site try the following key.
1-HBC66-D6YR7-CRP7H-T8VP4-99PMW
2-QXMDH-CRYFM-QFR87-HB783-T7RFQ
3-P37JV-FYJ32-YHH3T-KX7GX-7BJY3
4-HRMGX-K8WKJ-7FBGW-FTBCY-DWCM3
5-RCFMT-WFT7M-R779R-BJQMB-M2KWD
6-T9HJX-4C3BM-MG2R6-WC933-RCBRT
7-BTT7P-9HBFP-6QHM7-RFHDV-X8XWG
8-HWMMV-7H4DT-J2PJ6-YB8X4-VQCM6
9-JM2QC-KMVTP-VR8GV-HJRKQ-YWXWG
10-BHD34-K6BT7-T6PXP-BXKT4-X3G8D
11-DDH8T-C2JGD-G6MWW-6CYBV-BDTB6

RATE THIS SOLUTION ACCORDINGLY

abhvp

Abhay Pujari

  • 148 Answers
  • Posted on Jun 10, 2009

SOURCE: how to edit microsoft office viewer excel page without installing

You need XL viewer OR any software which can edit excel files. Search on google for the same.

Anonymous

  • 10 Answers
  • Posted on Feb 15, 2012

SOURCE: I cannot unlock microsoft office 2007 doc. to allow me to edit

In your case this Office password recovery tool should help take your stress out it can automatically find your forgotten password for protected Office Word doc, Excel, PowerPoint etc. Whatever the document is password protected to be opened or editing, it will help.

Best regards here.

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

What is the "&" symbol for in excel 2010?
The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1)

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:
http://office.microsoft.com/en-in/excel-help/concatenate-function-HP010342288.aspx

(Important: Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.)
http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(Important: Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.)
http://office.microsoft.com/en-in/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx?CTT=1

GuruAid.com
Read full answer
Jul 30, 2014 • Microsoft Excel 2010
0helpful
1answer

I just bought a new desktop that has office starter on it. I have office 2007 that i want to load but it is an "update" version. Will this recognize office starter as a registered microsoft...
Microsoft Office Starter is a new product launched by Microsoft that comes only in a version that is pre-installed on certain computers. There are no genuine licensed CD, DVD or download versions of this product. It should therefore actually be Microsoft Office Starter 2010 that you have pre-installed on your computer.

So the simple answer to your question is no. An Office 2007 Update will have no effect on an Office 2010 application. Also, an Office 2007 Upgrade application will probably not install anything at all on your computer unless of course you have genuine licensed versions of Office 2000 or Office 2003 already installed on it that are capable of being upgraded.

Microsoft Office Starter 2010 has a perpetual license (never expires), so it is not immediately obvious why you would feel the need to upgrade it, unless there is a particular Microsoft Office function that you need which is not included in Starter.

Office Starter replaces the various Trial versions of Office that used to come pre-installed on some computers. Office Starter is a reduced functionality version of Office including basic versions of Word and Excel. Neither PowerPoint nor Outlook are available in the Starter format. Word and Excel Starter can be used as they are for an indefinite period of time or can be unlocked to the functionality of various full versions of Office by buying and downloading an activation code from Microsoft. Starter can be used to open any Microsoft Word or Excel documents or spreadsheets and can also be used to perform basic editing of such documents and spreadsheets (a number of sophisticated tools and functions do not feature in Starter and are available only in the full versions of Microsoft Office).

If you do not want or cannot afford to upgrade Starter to a full-function version of Microsoft Office 2010, then a free full-function Office suite application called Open Office is available that is of similar quality to Microsoft Office and can also be used to open edit and manage Microsoft Office documents spreadsheets and databases. Open Office is available to download install and use totally free of charge (like other Open Source applications) from:

www.openoffice.org
Read full answer
Oct 06, 2011 • Microsoft Office Professional 2007 Full...
1helpful
3answers

Need a key password for office 7.
Anyone who’s ever tried to open or edit an important Microsoft Word or Excel document, only to find it’s protected by a long-lost or never-known password, will appreciate SmartDoctor’s Office Password Recovery 5.0. It’s a handy tool that unlocks password-protected Word, Excel, PowerPoint, and Access documents so they can be opened and edited by anyone. You can also use it to recover forgotten Office passwords. It’s compatible with all versions of Microsoft Office from 97 to 2007.
Read full answer
May 25, 2010 • Microsoft Office Home and Student 2007...
0helpful
3answers

What to pay attention to in converting Word to PDF? After completed the authoring or editing in Microsoft Word application, people are eager to convert the Word documents to PDF files, but what should...
noted
Read full answer
Apr 13, 2010 • Computers & Internet
1helpful
7answers

How to edit the text in pf
You will need to convert the PDF document to editable format. This software can help you do this: http://www.pdftodocconverterpro.com
Read full answer
Dec 08, 2009 • Avanquest Nitro PDF Professional
0helpful
1answer

How to convert Excel data in to Tally a accounting software
Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed or You can do 2 things , first you could export as text and import it back to excel using the text file you created , secondly you can select HTML and give the file name as eg-XYZ.xls
 or Try using UDIMagic Free Edition to Export Tally data. Download it fromhttp://www.rtslink.com/images/udimagic-free-edition-setup.zip 
Read full answer
Jan 06, 2009 • Microsoft Excel for PC
0helpful
1answer

Need Formula
TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.
Read full answer
Dec 15, 2008 • Microsoft Windows XP Home Edition
0helpful
2answers

Steps in saving file in excel to database
severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft
Read full answer
Dec 11, 2008 • Microsoft Computers & Internet
0helpful
1answer

Dreamweaver CS3
Import Microsoft Office documents (Windows only) You can insert the full contents of a Microsoft Word or Excel document in a new or existing web page. When you import a Word or Excel document, Dreamweaver receives the converted HTML and inserts it into your web page. The file’s size, after Dreamweaver receives the converted HTML, must be less than 300K.
Instead of importing the entire contents of a file, you can also paste portions of a Word document and preserve the formatting.
Note: If you use Microsoft Office 97, you cannot import the contents of a Word or Excel document; you must insert a link to the document.
  1. Open the web page into which you want to insert the Word or Excel document.
  2. In Design view, do one of the following to select the file:
    • Drag the file from its current location to the page where you want the content to appear.
    • Select File > Import > Word Document or File > Import > Excel Document.
  3. In the Insert Document dialog box, browse to the file you want to add, select any of the formatting options from the Formatting pop-up menu at the bottom of the dialog box, and then click Open. Text Only Inserts unformatted text. If the original text is formatted, all formatting will be removed.
    Text With Structure Inserts text that retains structure, but does not retain basic formatting. For example, you can paste text and retain the structure of paragraphs, lists, and tables, without retaining bold, italics, and other formatting.
    Text With Structure Plus Basic Formatting Inserts both structured and simple HTML-formatted text (e.g., paragraphs and tables, as well as text formatted with the b, i, u, strong, em, hr, abbr, or acronym tag).
    Text With Structure Plus Full Formatting Inserts text that retains all structure, HTML formatting, and CSS styles.
    Clean Up Word Paragraph Spacing Eliminates extra space between paragraphs when you paste your text if you selected Text With Structure or Basic Formatting. The contents of the Word or Excel document appear in your page.
Source: Dreamweaver CS3 Help
Read full answer
Feb 06, 2008 • Adobe Photoshop 7.0 for PC
0helpful
2answers

FORMULA FOR TEXT FORMATING
Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.

Please see link http://www.techonthenet.com/excel/questions/cond_format1.php
Read full answer
Nov 29, 2007 • Microsoft Excel for PC
Not finding what you are looking for?

View Most Popular

Excel for PC

  • Computers & Internet

Related Question

What is the "&" symbol for in excel 2010?

  • Microsoft Excel 2010

Related Topics

121 views

Ask a Question

Usually answered in minutes!

Popular Questions

CSV file to Import correctly into Excel 2003

Microsoft Excel for PC

Indian Rupee format in Excel spreadsheet

Microsoft Excel for PC

How to select all sales entry in tally 9 and how to delete it

Microsoft Excel for PC

Excel file opens in read only mode

Microsoft Excel for PC

Using excel to solve problem by trial and error method

Microsoft EXCEL 2004 for Mac

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...