+ Reply to Thread
Results 1 to 22 of 22

Can't type on a spreadsheet

  1. #1
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Can't type on a spreadsheet

    For some reason i can not add or delete letters or numbers. Left click does not give me the blinking line to type.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Can't type on a spreadsheet

    Maybe if you double-click?
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Can't type on a spreadsheet

    Is the sheet protected? You will know if it is protected if you double-click. A Message Box will pop up that says:

    The cell or chart you are trying to change is protected and therefore read-only.

    To modify a protected cell or chart, first remove protection using the Unprotect Sheet command. You may be prompted for a password.

  4. #4
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    When I double click,the word or number I am trying to change is framed in blue.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Can't type on a spreadsheet

    can you upload the workbook for us to take a look at?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    It's all very personal.But i just opened a new workbook and typed a short sentence then tried to go back to change a word and i could not.
    BTW: I can send you that [if you tell me how].
    Last edited by 420benz; 10-10-2012 at 04:26 PM.

  7. #7
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54
    Did not open
    Last edited by 420benz; 10-10-2012 at 12:12 PM. Reason: Did not open

  8. #8
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    I added the new workbook to the desktop and tried to paste it but to no avail. [above]

  9. #9
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Can't type on a spreadsheet

    Click the button [Go Advanced] at the bottom right of this page. On the next page click [Manage Attachments].
    From there you can upload the workbook.

  10. #10
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    Workbook6.xlsx
    This does not look right.

  11. #11
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    Try this one.
    Attached Files Attached Files

  12. #12
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Can't type on a spreadsheet

    Quote Originally Posted by 420benz View Post
    Try this one.
    I opened the file on both a Mac (Office 2011) and my PC (Office 2007) and was able to edit the cell just fine. It might be an error on your machine. If I recall correctly, there is a way to Rebuild/Repair Microsoft products:

    Go to Control Panel. If Windows XP, open Add/Remove Programs. If Windows 7, open Programs and Features.
    Click on Office 2010 and run the Repair option.
    Maybe that will help fix the problem?

    - Vince

  13. #13
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    It is Office 2011 on a Mac. Any fix available?

  14. #14
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Can't type on a spreadsheet

    I would try re-installing Office 2011. That is my only guess. Sorry.

  15. #15
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    Quote Originally Posted by Moo the Dog View Post
    I would try re-installing Office 2011. That is my only guess. Sorry.
    If i re-install Office,what will happen to my Workbooks?

  16. #16
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Can't type on a spreadsheet

    You shouldn't lose any personally created files - obviously backup any of your work before re-installing. Also, any custom Add-Ins or settings that you use would be gone. You would have to re-install/re-set those as well. If you installed any fonts in the Microsoft Font library you should back up those too.

    Can't think of anything else at the moment, but there may be more - maybe someone else who knows Macs better than I do has some more insight.

    - Vince

  17. #17
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    After re-installing i still have the same problem.I can't find a phone # for Microsoft Support.

  18. #18
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Can't type on a spreadsheet


  19. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Can't type on a spreadsheet

    nothing should happen to your files, but to be on the safe side, if you save them inside the "office" folder (which is not the default) move then to some place else. you can then retrieve them when you have reinstalled

  20. #20
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Can't type on a spreadsheet

    Before you start re-installing things, can you check something in the settings (see menu Extra->Options and then select the edit tab.
    The checkbox "direct cell editing" should be enabled. If I disable that option I can't type directly in a cell, but I can still edit the contents of the cell thru the formula bar.
    I'm not sure about the naming of the option (my excel is Dutch), but I'm sure you can find it and check it.

  21. #21
    Registered User
    Join Date
    05-23-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Can't type on a spreadsheet

    Quote Originally Posted by Tsjallie View Post
    Before you start re-installing things, can you check something in the settings (see menu Extra->Options and then select the edit tab.
    The checkbox "direct cell editing" should be enabled. If I disable that option I can't type directly in a cell, but I can still edit the contents of the cell thru the formula bar.
    I'm not sure about the naming of the option (my excel is Dutch), but I'm sure you can find it and check it.
    This is what I did.Preferences-Edit There is no (direct cell editing) box to enable.Double click box is checked. I might be in the wrong place.
    BTW:This is on a Mac.
    Last edited by 420benz; 10-11-2012 at 07:55 PM.

  22. #22
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Can't type on a spreadsheet

    In Excel 2010 this should be in Files -> Options -> Advanced.
    I'm not familiar with Mac, but I assume it will be in the same place.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1