Home > In Excel > Unable To Do Anything In Excel

Unable To Do Anything In Excel

Contents

On the Protection tab, select the Locked check box, and then click OK. If you're having a computer problem, ask on our forum for advice. I didnt find any *.xml and i have all the correct hidden files shown in my folder options. "Max" wrote: > Not sure, but try this post: http://tinyurl.com/cvppr > -- > Happens intermittently, but very very frequently. navigate here

This is a security feature that you can ... Delete the graphic number ( a square or an L) located before zone number 0. Ask Your Own Question Edit Links Greyed Out? - Excel Excel Forum I've read a bit on the web about there being a bug with the 'edit links' feature. How/Can I get this function to work? http://superuser.com/questions/846236/unable-to-enter-anything-into-a-cell

Can't Type In Excel Cell

Users can change the values in the changing cells, if the cells are not protected, and add new scenarios. Open Menu Close Menu Apple Shopping Bag Apple Mac iPad iPhone Watch TV Music Support Search apple.com Shopping Bag : CommunitiesSign inPostBrowse discussionsContact SupportSearchCommunitiesContact SupportSign inContentPeopleSearch Support CommunitiesMac OS & System To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! Wednesday, August 12, 2015 11:09 PM Reply | Quote 0 Sign in to vote I had two Excel spreadsheets open at the same time.

  1. Leave your own comment: *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What
  2. If you double click the fill handle in 2003/2007 you would fill the series, now it just does in cell editing.
  3. V_R posted Dec 21, 2016 at 1:14 PM Custom titles are active Becky posted Dec 21, 2016 at 12:14 PM Co-op game recommendations Ian posted Dec 21, 2016 at 11:36 AM
  4. That solves so many problems it's really a waste of your time (and others) to seek help before trying this solution. –Twisty Nov 28 '14 at 23:00 add a comment| 5
  5. Tuesday, September 30, 2014 8:58 AM Reply | Quote 0 Sign in to vote This worked for me!
  6. It then goes on to say about portions not being encryted.

It doesn't matter if I edit the text in the cell or in the formula bar.hitting enter (this seems to be key to triggering it). Wednesday, February 25, 2015 8:22 PM Reply | Quote 0 Sign in to vote Same issue here, have been dealing with it for months, driving me insane. Powered by vBulletin Version 4.1.8 Copyright 2012 vBulletin Solutions, Inc. Can't Type In Excel 2010 It is also greyeing out the same options in the contextual right-click menus.

current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. Excel Won't Let Me Type In Cell 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)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 Objects Making changes to graphic objects — including shapes, text boxes, and controls — unless you unlock the objects before you protect the chart sheet. I can't figure out how they created it/locked it down like this.

Our Company Sharon Parq Associates, Inc. Excel Won't Let Me Type Numbers The last file I worked on with this problemhad all text, no formulae. Please help im > racking > > my brain! > > > Register To Reply 06-04-2005,10:05 AM #4 Max Guest Re: I can't edit anything in my Excel spreadsheet! Dec 29, 2014 3:47 AM Helpful (0) Reply options Link to this post by JEL888, JEL888 Jan 26, 2015 8:01 AM in response to shanefrommaidstone Level 1 (19 points) Mac OS

Excel Won't Let Me Type In Cell

Thanks again for your comments Sparkelberry Nov 30, 2014 3:44 PM Helpful (0) Reply options Link to this post by shinufromnorthvale, shinufromnorthvale Dec 16, 2014 10:55 PM in response to mo-no see it here Copy the data into a totally new Excel sheet, see if it lets you do that. Can't Type In Excel Cell My excel is practically useless in this format and I can't find anything on the Microsoft website to fix this. Can't Enter Data Into Excel Cell I've been working within Excel today and to my amazement I've been unable to copy cells from 1 page in the work book to another page.

To see how user names should be entered, click examples. http://brrian.net/in-excel/unable-to-edit-cells-in-excel.html The chart continues to reflect changes made to its source data. Wednesday, December 07, 2016 6:18 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Technet Web site. Guest, Jun 4, 2005 #1 Advertisements Max Guest Maybe sheet/book protection is accidentally activated? Excel 2013 Cannot Type In Cell

Register To Reply 06-04-2005,11:05 AM #5 Atrocity Guest Re: I can't edit anything in my Excel spreadsheet! Thursday, November 05, 2015 4:54 PM Reply | Quote 0 Sign in to vote This doesn't work. Has anyone found a solution yet (besides closing active sheets - NOT an acceptable answer). his comment is here Chart sheet elements Select this check box To prevent users from Contents Making changes to items that are part of the chart, such as data series, axes, and legends.

So my thinking is do a password protect to open and then a further password to edit. Excel Won't Let Me Type Mac That’s why it’s often better to uncheck the Locked box for everything first, before choosing the specific cells you want to lock. Any help would be greatly appreciated.

All contents Copyright 1998-2016 by MrExcel Consulting.

Win8.1 pro, Office 2013 (32bit) Sunday, March 08, 2015 3:50 PM Reply | Quote 0 Sign in to vote Same problem and fix for me. Edit: fixed it by using the keyboard shortcut ALT-DOWN to bring up the autofilter drop-down menu and selecting something different. Thanks for your help in advance. Can't Type Numbers In Excel I can paste text into cells, but totally can't use the keyboard to write into them.

Ste ... solution Copy/paste weird problem solution More resources Ask the community Tags Example: Notebook, Android, SSD hard drive Publish a b ǰ Top Experts Apps basroil 8636 messages since 10/19/13 hang-the-9 41595 I have also tried older files that were known to work 3-4 months ago with shared feature, but now - the right click tab menus also are greyed out. http://brrian.net/in-excel/unable-to-edit-hyperlinks-in-excel.html Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.

Clicking into another worksheet in the same spreadsheet and back again fixes it for me. Share Share this post on Digg Del.icio.us Technorati Twitter Surrender be on good terms with all persons. Posts 13,686 Re: Excel file - can't select cells, weird issues Have you checked if the file has any macros? Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd.

Proposed as answer by Lrkin Monday, December 08, 2014 9:41 PM Friday, August 08, 2014 11:34 PM Reply | Quote 0 Sign in to vote Hi I had exactly the same It's ridiculous that we can't have multiple files open at a time. From what I've been reading it seems that Excel won't allow focus to change while in edit mode. I followed the advise from excel but the advanced box "edit directly in Cell" was already checked.

Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Friday, November 08, 2013 1:58 AM Tuesday, November 05, 2013 9:33 AM Reply | Quote Moderator All replies 0 Sign in I didnt find any *.xml and i have all the correct > hidden files shown in my folder options. When I use the autofill feature it simply does not work. If Delete columns is protected and Insert columns is not also protected, a user can insert columns that he or she cannot delete.

Any other feedback? Stay logged in Welcome to PC Review!