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

Ad

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

Ad
  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers

Hello!

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!

Heather

Posted on Jan 11, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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


remosofts,

  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!
-Gort.

Oct 11, 2010 | Microsoft Office Standard for PC

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

1 Answer

I need to find out how to scan a paper from the scanner to my computer so I can make changes on the paper.the printer is a 6100injet all in one HP


If you installed the software from the CD, then:
1. put document in feeder
2. on the computer
[Start]
[All Programs]
[HP 6100]
[Scan to OCR]
The scanner will scan the document pages and put them on your computer.
It will automatically open your wrodprocessor program (MS Word?)

The OCR (optical character resolution) will be less than 100% accurate and will not handle pictures.
It will also have problems with "tables" and inserted items like Excel sheets.

Best thing to do is to request that the original document be emailed to you instead.

Hope this helps!




Sep 23, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

My excel sheet is opeaning very slow about 30 40 sec


there could be several reasons for that:
1. do you have links pointing to another excel/website/folder/db query? if so- it is probably trying to import data from it. the most common is to try and import data from another excel sheet- you need to have that excel open before you open this on
2. what is the size of your excel file? if it's big- try to see if you can break it to several excel sheets.
3. what type of hardware do you have? do you have enough memory?

can you provide more details?

Aug 09, 2009 | Lenovo IdeaCentre K210 - 53133BU 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

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

2 Answers

Excel work sheets delete,pls how is it restore


Easiest way would be to use the Undo function to work your way back to the point prior to deleting the worksheets. If you can't back up through the list that far, you could close the file WITHOUT SAVING IT, then reopen the original file again. If you have already saved the document after deleting the worksheets, you will have to restore it from a backup (you do perform backups, right?) and continue working fro there.

Apr 15, 2009 | Microsoft Computers & Internet

10 Answers

Excell Password


5a6e9ecb-a5cc-4ddc-a33e-3db0180df311.png
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

1 Answer

One problem in the application of excel sheet


I can make out that
You are speaking about creating a macro to take data from one constant updated cell and to put that data into another cell or form sheet.
You will need to get precise help from a programmer on this.
If you want to see a little on macros just open a sheet and checkout the help section on macros.
Some macros can take many hours to write and test.Some make take months.
hope this helps.

Jan 30, 2008 | Microsoft Windows XP Home Edition

2 Answers

HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET


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

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...