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.

Reply ajit says: September 3, 2015 at 3:42 pm if right click insert not working, on top (home) go to cells there insert, delete are there. http://skimwp.org/in-excel/cannot-enter-text-in-excel.php View 1 Replies View Related Home Submit Resource Tracker Forum Advance Search Privacy Policy| Terms of Use & Service| Contact Us| Copyrights Notice Copyrights 2005-15 www.BigResource.com, All rights reserved

How to Enter Data into Excel Entering data into Excel is exactly the same across all Excel versions and can be done in a number of different way ... An entire row or column Click the row or column heading. 1. Can't Type In Excel Spreadsheet

  • Cells to the beginning of the worksheet Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.
  • The equivalent steps to sort out the rows are: Find the last row in which data appears (row 100, say) Highlight the subsequent row (row 101) CTRL+Shift+Down ALT, E, A, A.
  • Force To Enter Data Upon Selection Of Other Enter Data In Cell, But Keep Formula As Well If A Cell Is Empty Then Enter Data From Another?
  • but when i deleted it still doesn't work.
  • To apply the default date or time format, click the cell that contains the date or time value, and then press CTRL+SHIFT+# or [email protected]
  • View 3 Replies View Related Macro - Enter Data In Next Clear Row After Every Run Jun 27, 2014 I have a macro that- copies rows from one sheet into another
  • I can't even click on anything in the toolbar.
  • If I double-click a cell then I get the cursor back and I can enter into this and subsequently other cells from then on.
  • I pressed escape to get rid of the grey cells.Excel would not let me type any numbers againin the cells anymore.
  • Reply Swarupa says: September 6, 2016 at 6:17 am Very good tip.

You can also enter the same data into several cells by using the fill handle to automatically fill data in worksheet cells. More Resources About AccountingWEB About Sift Media Advertise on AccountingWEB Terms of use Privacy policy Contact us Got a question? Any help is GREATLY appreciated. Get More Info Attached Files Excel blank file.xlsx 7.48KB 56 downloads Back to top Report #2 Jonathan Jonathan Forums Administrator Administrators 756 posts Posted 17 May 2015 - 03:46 PM I have taken a

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 -

Top Excel Keyboard Shortcuts to Increase Productivity I'll show you the top keyboard shortcuts for Excel that are sure to increase your productivity.

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.