Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Can't format cells anymore in Excel 2007

This is a discussion on Can't format cells anymore in Excel 2007 within the Excel Questions forums, part of the Question Forums category; Up until today, Excel worked fine and I was able to insert rows and columns, copy rows and columns and ...

  1. #1
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Question Can't format cells anymore in Excel 2007

    Up until today, Excel worked fine and I was able to insert rows and columns, copy rows and columns and Insert Copied Cells, and format cells by selecting, right-clicking, and choosing Format Cells. Today I can't do any of those things. I have searched all over the internet and all I have found is people asking "is it a shared workbook?" or "is the sheet protected?" I'm not an Excel idiot so I assure you the answer to those questions is no. It happens if I open a brand new workbook or an existing one, if I copy and paste special values or just type new values in the cells. What could possibly be causing this?

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,517

    Default Re: Can't format cells anymore in Excel 2007

    Welcome to the Board.

    Do you mean that your right-click menu has disappeared?
    Microsoft MVP - Excel

  3. #3
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Default Re: Can't format cells anymore in Excel 2007

    No, the menu stills appears when I right-click, but Format Cells and Insert Copied Cells are grayed out. I can't attach a screenshot so I uploaded one to TinyPic. I was trying to Insert Copied Cells in this example.


  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,517

    Default Re: Can't format cells anymore in Excel 2007

    That looks like the menu choices you get when the worksheet is protected and the user is allowed to format rows.
    Microsoft MVP - Excel

  5. #5
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Default Re: Can't format cells anymore in Excel 2007

    Why would I open a brand new blank workbook, enter data in a few cells, and then not be able to insert a row though? I didn't tell Excel to make these workbooks protected. Also, when I look at the Review tab, it says they aren't protected, so this cannot be the problem.

  6. #6
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,517

    Default Re: Can't format cells anymore in Excel 2007

    Something must be disabling (or has disabled) the menu choices. Do you have any macros? Is your new workbook based on a template?
    Microsoft MVP - Excel

  7. #7
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Default Re: Can't format cells anymore in Excel 2007

    I checked and there aren't any Macros and my new workbook was just a regular Blank Workbook, not from a template. Thank you for taking the time to troubleshoot this issue with me, by the way.

  8. #8
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,517

    Default Re: Can't format cells anymore in Excel 2007

    Can you EMail the workbook so that I can have a look? Check your PM for the address.
    Microsoft MVP - Excel

  9. #9
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Default Re: Can't format cells anymore in Excel 2007

    I figured out what happened. I get a file from a customer that requires macros to be enabled and whenever it's open I cannot change formatting in other workbooks that are open. If I close out of their file, everything works fine. I don't understand why macros in one file would affect all other open files, but at least the issue is resolved. Thanks!

  10. #10
    New Member
    Join Date
    Aug 2011
    Posts
    1

    Default Re: Can't format cells anymore in Excel 2007

    I am having the exact same problem as listed in this thread. However, the Macro thing is not the issue. This disabling of Insert, Delete, and Format Cells seems to be permanent. Even when I reboot the computer, it still persists. I even disable macros completely. It still does not work.

    Please help!

Page 1 of 2 12 LastLast

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com