Question about Microsoft Excel for PC

2 Answers

Problem with excel

I have a problem with excel sheet,when i was open the excel data i found junk character in sheet instead of original data.

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: problem with excel

If I click on a cell it goes into autofill mode and won't do anything else. I have to ctrl-alt-delete to get out of the situation. I've rebooted and everything but every time I go to a new sheet and click on a cell it does it. If I open a sheet and use the up and down arrows and don't use the left mouse button I'm okay. Is it my mouse? It works on the internet and all other applications but not Excel.

Posted on Apr 27, 2008

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers
Re: problem with excel


Have you tried a simple restart of Excel and/or your computer? That would be my 1st recommendation. If that doesn't work, make sure the font formatting for the cells is correct (this seems simple but could be overlooked perhaps). If that doesn't work you may try to repair/reinstall Excel (use the Office disc).

Let me know if you need additional help or if that doesn't work. Any additional information you can provide would be very helpful though.

Best of luck!


Posted on Jan 11, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

I want to save and retrieve some data from html page to excel. how to do this


  1. In a blank Excel sheet (or blank tab), click on the cell where you want the html page to begin placing data.
  2. From the top menu, select [Data] and choose [Get External Data] from the drop-down menu.
  3. Select [New web query] (view other options for future queries)
  4. A pop-up screen will have a few options, of course enter the html page location in the first box (Web address)
  5. You probably want to also select *The entire page (instead of only 'tables' default)
  6. Click [OK] and look at the data in your Excel sheet!
  7. You may want to adjust the options in future data retrievals.
Thanks for choosing FixYa!

Oct 11, 2010 | Microsoft Office Standard for PC

3 Answers

How can I launch without recover.c

Look for the answer here:

XLSX Repair Kit. The latest corrupt XLSX file repair software featuring a powerful data recovery core and a convenient step-by-step wizard for extra convenience.
For more information:

Dec 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

"Delimited" gibberish in Excel

You could try to change the whole workbook font to a known good one or do it a sheet at a time by doing a "select all" then setting the font.

It sounds as if though you are trying to import a web page including the HTML code which may well cause the problem you see.

I prefer to do that type of thing with a
"Get External Data"
"new web query"
which will put things into a sheet in such a way as you can use them in other calculations

Whenever you open the sheet it will go and get the latest information for you automatically so you can then select what you want and copy that to another sheet. to use to keep track of things.

Oct 17, 2009 | Microsoft Excel 2003 (065-03992) for PC

2 Answers

Excel data is Delimited

Try opening the file from the Excel File/Open menu rather than double clicking to open it.  If that does not work try Importing from it into a new blank spreadsheet.

Jun 01, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Cannot open excel file

if you saved the file with any of these characters (!@#$%^&*()+=) in the file name, Excel will not recognize the name
you will have to rename the file
right click on the icon for the file and rename it with .xl as the extension, you will then be able to open it

May 02, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

When I enter a formula the cell displays the formula and not the result. For instance, I type: =left(L27,13) Instead of showing me the 13 leftmost characters in cell L27, it shows ''=left(L27,13)''. Any...

You can change this under the Excel, options menu. Select the advanced option and uncheck the option to "Show Formulas in cells instead of their calculated value", or you can jjst press Ctrl + `
This will either turn on or off the show formula option.

Apr 27, 2009 | Microsoft Excel for PC

9 Answers

Excell Password

Would you like to recover excel file password so just try PDS Excel password recovery software this software quickly works on your password protected Excel file and get back your original Excel file password, This Microsoft Excel file password recovery software magnificently recover password MS Excel file and also let you use your locked XLS and XLSX file again without creating any problem more. With the help of MS Excel sheet password recovery software you can easily recover password MS Excel sheet with fully previous data of your locked Excel file. PDS Excel file unlocker tool gives you free Excel unlocker software which shows you first three characters of your original Excel file password. if you want to recover whole Excel file password then you can get full version software.

Free Excel Password Recovery
Buy Excel File Unlocker

Mar 04, 2008 | Microsoft EXCEL 2004 for Mac

2 Answers

Duplicacy in excel sheet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

2 Answers


The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.

The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.

For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.

The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.

The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).

How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.

Please ask any questions.

Dec 18, 2007 | Microsoft EXCEL 2004 for Mac

1 Answer


There is an easier way. in your workbook with the worksheets to consolidate, insert a new blank sheet. from the DATA menu, select consolidate. click ADD and go to the first sheet, select the required information (best to select all headings aswell). Continue this procedure for each sheet. at the bottom of the Consolidate dialog box, check all three options for links. and click OK. This should now give you a consolidation of all your sheets.

Hope this solves your problem

Oct 09, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

99 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides