Home > In Excel > Cannot Enter Data In Excel 2010

Cannot Enter Data In Excel 2010


Why would you only be able to have one Excel file open at a time be a feature? Powered by vBulletin Version 4.1.8 Copyright 2012 vBulletin Solutions, Inc. The last file I worked on with this problemhad all text, no formulae. Tuesday, August 18, 2015 7:41 PM Reply | Quote 1 Sign in to vote Same or similar problem here. useful reference

It consist of four columns with either numeric or alpha data in the. Register To Reply 05-31-2010,03:36 PM #6 NBVC View Profile View Forum Posts Forum Expert Join Date 12-06-2006 Location Mississauga, CANADA MS-Off Ver 2003:2010 Posts 34,884 Re: unable to enter data in Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General unable to enter data in Excel 2007 To get replies Any suggestions? http://superuser.com/questions/846236/unable-to-enter-anything-into-a-cell

Can't Type In Excel Cell

Select File->Options->Advanced from the excel menu bar. 2. It's utterly baffling! If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!!

  1. How can I go back to default setting?When I close this without saving.
  2. I have found that using the Num Lock keys do not work at certain times within the cells.
  3. win 7 x32, Office 2013 x32 Someone found solution?
  4. Buy new mouse and keyboard - no change.
  5. Readers Activity Go to top TopicsWindows Mac OS X Linux iOS Android Windows Phone Office Web Authors Fatima Waqas Hamza Adi Daily articles in your inbox each day for free Close
  6. Login.
  7. Try uninstalling and reinstalling Rgds Register To Reply 07-16-2014,11:00 AM #5 Jane B.
  8. Register To Reply 05-31-2010,05:37 PM #11 stc2011 View Profile View Forum Posts Registered User Join Date 05-31-2010 Location USA MS-Off Ver Excel 2007 Posts 7 Re: unable to enter data in
  9. I followed the advise from excel but the advanced box "edit directly in Cell" was already checked.

Have there been any other solutions to the problem most have posted about having? On the worksheet, click a cell, and then enter the number that you want. Type the numbers or text that you want to enter, and then press ENTER or TAB. Can't Type In Excel 2010 All cells on a worksheet Click the Select All button.

Cannot enter data into an Excel workbook Started by W123456, May 17 2015 12:19 PM select cells keyboard Please log in to reply 1 reply to this topic #1 W123456 W123456 Can't Enter Data Into Excel Cell This is what is causing the issue with not being able to edit cells. I will try the temporary solutions that you have provided for now, but a more permanent fix would be nice. Meaning of double bracket "[[foo()]] type name;" syntax in c++?

Thursday, October 31, 2013 7:06 AM Reply | Quote Answers 0 Sign in to vote Have you checked if you disabled 'allow editing directly in cells'? 1. Excel 2013 Cannot Type In Cell Note: Numbers that you entered before you applied the Text format to the cells must be entered again in the formatted cells. Microsoft Customer Support Microsoft Community Forums TechCenter   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 These two options available at the bottom of 'Advanced' option.

Can't Enter Data Into Excel Cell

Also, my mouse wheel won't scroll the spreadsheet.Dragging the mouse over the scroll bar will scroll the spreadsheet. http://forums.excelcentral.com/index.php?/topic/844-cannot-enter-data-into-an-excel-workbook/ The rectangular range between the active cell and the cell that you click becomes the new selection. Can't Type In Excel Cell It started after I upgraded her to 2013. Excel Won't Let Me Type In Cell Wednesday, April 22, 2015 7:29 PM Reply | Quote 0 Sign in to vote It seems that there are a number of us with this issue.

However, the column is only wide enough to display six characters. see here To select the entire worksheet, you can also press CTRL+A. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. Can't Type In Excel Spreadsheet

Wednesday, September 09, 2015 8:50 AM Reply | Quote 0 Sign in to vote I have the same problem but NONE of these fixes work for me. A friend (who lives a fair distance away) has a very simple Excel 2007 spreadsheet. Help microsoft-excel share|improve this question edited Nov 29 '14 at 6:23 fixer1234 11.2k122950 asked Nov 28 '14 at 20:44 Sandra 16112 What happens when you enter a date in this page Remember Me?

To view worksheets in the active workbook only, in the Arrange Windows dialog box, select the Windows of active workbook check box. Can't Type Numbers In Excel On the active worksheet, select the cell or range in which you want to edit existing or enter new data. I will try that next. –Sandra Nov 28 '14 at 21:40 1 @Sandra For future reference, try restarting your computer before putting your time into asking others for assistance.

Are there any other applications open in memory at the same time?

Figuring out why I'm going over hard-drive quota Are “Referendum” and “Plebiscite” the same in the meaning, or different in the meaning and nuance? Join the community of 500,000 technology professionals and ask your questions. Adjacent rows or columns Drag across the row or column headings. Excel Won't Let Me Type Numbers As an alternative to increasing the width of a column, you can change the format of that column or even an individual cell.

Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Jump to content share|improve this answer edited Nov 1 '15 at 18:10 bmende 78112 answered Sep 17 '15 at 18:27 NC Admin 11 add a comment| up vote 0 down vote It seems that She emailed the spreadsheet to me and it works fine, I can enter data without problems. http://skimwp.org/in-excel/cannot-enter-text-in-excel.php On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click the format that you want.

asked 1 year ago viewed 34348 times active 3 days ago Related 4How can I avoid Excel reformatting the scientific notation numbers I enter?2Copy information to one cell based on what's Jan 26, 2015 8:01 AM Helpful (0) Reply options Link to this post by Juno96, Juno96 Oct 15, 2015 4:18 PM in response to mo-no Level 1 (8 points) iPad Oct Check and see if what you typed is still in the formula bar or not. This is what is causing the issue with not being able to edit cells.

This should correct the problem. To select Do this A single cell Click the cell, or press the arrow keys to move to the cell. If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve. The next cell down is now highlighted.Try to type--nothing happens.

This is a workaround and not a fix. More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. Close the other documents, and re-open your Excel File. Change to manual Calculation - nonsense, everytime after edit cell tap F9 for recalculation (that's right I buy a notebook and a calculator).

current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Top of Page Enter the same data on several worksheets at the same time By making multiple worksheets active at the same time, you can enter new data or change existing When you enter or edit data, the changes affect all the selected worksheets and can inadvertently replace data that you didn't mean to change.

Column heading You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW Recorded Future allows analysts to observe structured data on the open, deep, and dark web. Thanks again. To stop adding cells or ranges to the selection, press SHIFT+F8 again.