Home > In Excel > Unable To Enter Data In Excel 2003

Unable To Enter Data In Excel 2003

Contents

under 'fill' go to 'fill effects'...click on the picture tab.. The only way to exit is to use Ctrl+Alt+Delete and switch offf Excel completely. current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. Click 'Insert Sheet Columns'. weblink

use it. 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. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. Advertisement This occurs when Excel considers used range of the worksheet to encompass all columns or rows. http://superuser.com/questions/846236/unable-to-enter-anything-into-a-cell

Can't Type In Excel Cell

Same with using the enter key. A case like this could easily cost hundreds of thousands of dollars. I am unable to enter any letters or numbers into cells.

  • In that case cell A1 is highlighted with a box around it indicating to the user this is where the input is.
  • Can you help me?
  • Reply Diana says: January 30, 2015 at 10:38 am Many thanks - so very helpful....
  • It happens on all of her .xls files.
  • None of which seem to work right.
  • Hope this help.
  • It's very helpful.
  • This action will add this to 'New Tab' created.
  • Just to add some keywords for people to find this thread easier, let me add: Right-click autofill popup menu is disabled in excel Edited by damdare, 14 November 2016 - 05:44
  • Any help?

Removed the merge. Thanks! I had another (timesheet) spreadsheet open, with hundreds of worksheets. Can't Type In Excel 2010 Thanks.

Thank you! Excel Won't Let Me Type In Cell Thanks See more Excel Date Formatting Not Working Im unable to make formating in excel Excel format date not changing Change Date Format in Excel I want to change date format its working good thanks. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/i-cannot-enter-any-numbers-or-letters-in-excel-i/a0efa8af-b10c-42f2-b5e5-58dcdd3001e0 Thanks (0) By leahplotkingmailcom Jun 26th 2015 01:11 awesome!

Check and see if what you typed is still in the formula bar or not. Unable To Enter Data In Excel Cell It's driving me batty. Reply lei says: April 14, 2013 at 3:36 am it didn't work. 🙁 i'm using pro plus 2010 and pretty sure followed all your steps. If that didn't work, then I was going to go through the select and delete steps.

Excel Won't Let Me Type In Cell

When I try to right-click the tab I get nothing. website here Top Excel Keyboard Shortcuts to Increase Productivity I'll show you the top keyboard shortcuts for Excel that are sure to increase your productivity. Can't Type In Excel Cell Helped. Can't Enter Data Into Excel Cell really helpful Reply Gill says: July 30, 2015 at 9:18 am We were mystified why we could not insert a column: this is genius!

Thanks in advance! have a peek at these guys Hope this help. Hopefully it will help someone? Reply Amit says: August 20, 2015 at 6:14 am MS Excel -2013 - Adding a Column or Row - Problem File-> Options Click on 'Customize Ribbon' Click 'New Tab', Rename if Excel 2013 Cannot Type In Cell

Reply Saurabh Shrivastava says: August 29, 2012 at 3:31 pm This is working in Excel 2003, Please suggest same for Excel 2007. I had gone crazy with it for hours then I luckily found you! GOD BLESS U 🙂 Reply Mushu says: February 11, 2016 at 10:17 am Thank you very much, it worked! 🙂 Reply Abraham Rohith Roy says: February 15, 2016 at 10:03 am http://brrian.net/in-excel/unable-to-enter-text-in-excel.html Thnx:-) Reply samkeenan says: June 23, 2014 at 12:17 pm Brilliant!

I can use the arrows and move around, the name box indicates this. Excel Won't Let Me Type Numbers or baring that you can insert a comment into the cell.. Can Mirror Image still work while being grappled?

Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

To reference a new cell you have to move your mouse pointer to it and click. Hot Network Questions What's the difference between ls and la? I'm NOT wanting an external cell to convert it for me i.e. Excel Won't Let Me Type Mac Jump to content Sign In Create Account Search Advanced Search section: This topic Forums Members Help Files Calendar View New Content Forum Rules BleepingComputer.com Forums Members Tutorials Startup List

Besides firing a lazy operator I would like to make it more user friendly and ensure that the data entry person is entering the comment. Additionally, sometimes when she clicks a cell, it will just select that one cell. Thanks (0) Please login or register to join the discussion. this content when entering text), I find that too many times, I come across jobs where I need the cursor to move down after hitting Enter.

share|improve this answer edited Nov 2 '15 at 4:17 answered Nov 1 '15 at 16:32 bmende 78112 add a comment| up vote 0 down vote I have had this problem. When it came back up, I could insert. Was driving me crazy!! I click on cell A1 (which contains 1/1/2010) it will return that value to cell F1.

Solved a work problem! Why does a (D)DoS attack slow down the CPU and crash a server? I looked around on the internet, and found a few suggestions. Additional information: This spreadsheet was able to do this previously.

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. Several functions may not work. They will be able to enter the field in accordance with the needs of how many.Best Delux Prince Of Wales Island Fishing Lodges Thanks (0) By bokins Jun 26th 2015 01:11 Excel was working fine since last 6 months but started facing same problem from last 3 days, if anybody has solution please let me know.Thanks in advanceImran Tamboli 0Votes Share Flag

Thanks heaps for your help!! That works. -24 View all 8 comments Report nik- Jun 11, 2010 at 08:13 AM Thanks a lot man Report noone- Sep 8, 2010 at 11:36 AM this is the best Ask Your Own Question Excel Highlighting Problem-(grouping And Highlights Of All Cells) - Excel Excel Forum Hi, I have had this problem for a while now, which occurs on and off. No then it vl display the data accordingly and if i edit the sheet three data then it will update it in the "data" sheet by button click without creating duplicate.

Thanks! Thanks Ask Your Own Question Why Do I Have To Click On The Cell & Enter For The Vlookup Towork - Excel Excel Forum I have set a VLOOKUP formula to