Home > In Excel > Cannot Enter Data In Excel 2007
Cannot Enter Data In Excel 2007
To enter data on a new line within a cell, enter a line break by pressing ALT+ENTER. How do I get the cursor to AUTOMATICALLY go back to TOP of form to the first textbox (named txtDate) ? (It just stays on "ENTER" control now). Tried several other solutions to my "can't insert rows in Excel" problem. then with that workbook I opened my file which was having probmem (by file Open mode "CTRL+O" and not by going through folder) then tried to incert column. http://skimwp.org/in-excel/cannot-enter-data-in-excel-2010.php
Hi, Then I suspect Excel has become corrupted. Posts 19,522 Re: Can't enter any data in Excel spreadsheet Hi, and welcome to the forum. There are so many menus that can be tried one by one. This action will add this to 'New Tab' created.
Can't Type In Excel Cell
We need your input to help create a new Live Online Excel Help service. worked for Outlook 2013. Top of Page Share Was this information helpful? Any help would be appreciated.
Basically it's acting as if I am click-holding and dragging wherever I move the mouse. Tip: To select a number format from the list of available formats, click More, and then click the format that you want to use in the Category list. Reply awal says: May 16, 2016 at 7:15 am worked great thanks Reply Farhan Khan says: June 6, 2016 at 3:24 pm Thanks a lot, that really helped. Can't Type In Excel 2010 I have to use the mouse and click on the cell I want to enter something into.
share|improve this answer answered Jun 15 '15 at 17:17 Aimee 1 add a comment| up vote 0 down vote It's not that you needed to close another workbook; all you need Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and 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. http://www.excelforum.com/excel-general/731346-unable-to-enter-data-in-excel-2007-a.html I need to add a new tab for a new employee so I had everyone exit from the workbook and then I unshared the workbook.
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. How To Enter Numbers In Excel Without The Formula 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. View 9 Replies View Related If A Cell Is Empty Then Enter Data From Another? Reply Saurabh Shrivastava says: August 29, 2012 at 3:31 pm This is working in Excel 2003, Please suggest same for Excel 2007.
Can't Enter Data Into Excel Cell
The first or last cell in a row or column Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP Get More Info Register To Reply 05-31-2010,07:17 PM #14 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 Can't Type In Excel Cell May 21, 2014 I have a huge (for a newbie ) spreadsheet where every item is associated with several key words. Excel Won't Let Me Type In Cell Thank you.
I can use the arrows and move around, the name box indicates this. Excel 2013 Cannot Type In Cell Hot Network Questions Were the Smurfs the first to smurf their smurfs? This means that a user will not be able to resave the workbook un Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter -
I have to do this for each cell. Thanks (0) By HaroldSalvatored Jun 26th 2015 01:11 Insert column will be a difficult thing if you and a lot of people do not know how. The cells do not have to be adjacent. Excel Won't Let Me Type Numbers I have tried looking in the Tools/Options/Edit menu, scroll lock key and all sorts of shift ctrl fn button combinations to no avail.
Pressing ENTER moves the selection down one cell, and pressing TAB moves the selection one cell to the right. Register To Reply 04-19-2008,03:17 PM #4 Richard Buttrey View Profile View Forum Posts Forum Moderator Join Date 01-14-2008 Location Stockton Heath, Cheshire, UK MS-Off Ver Excel for Windows & Mac - Reply Monika says: February 2, 2016 at 5:03 pm You are a genius! see here By carpetstains Jun 26th 2015 01:10 this great information i've learn on here so keep up the good inforamtion you've posted here guys Thanks (0) By carpetstains Jun 26th 2015 01:10
F2 allows me to enter the cell and type into it but the cursor is stuck inside and cannot reference any other cell. I select multiple sheets with ctrl+ or shft+click method and enter the data in the required cells.