Results 1 to 3 of 3

Thread: Format cells in Excel 2010

  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Format cells in Excel 2010

    I have recently moved from Office 2007 to Office 2010 and am having trouble with some of the formatting. Two problems:
    1) The format painter doesn't seem to work - how can I get it working?
    2) If I copy and paste a cell it pastes the value of the copied cell, not the formula. What do I need to change to make sure the default is to copy formula not content?

  2. #2
    Join Date
    Mar 2012
    Posts
    2

    Re: Format cells in Excel 2010

    I sorted both problems by rebooting the PC - just closing & restarting Excel didn't do it. Still don't know why these functions stopped working though...

  3. #3
    Join Date
    Aug 2011
    Posts
    564

    Re: Format cells in Excel 2010

    This look like some of the custom modification causing the problem. This can be fixed by a Macro but that process is a bit complicated. You can do one thing if you have Office Installation disc. Insert the disc and go in control panel > add remove programs. Choose Office and Click on Remove > Repair. The installation will fix any issue or corrupted file.

Similar Threads

  1. Format Painter does not work in Excel 2010
    By Leon.Sunny in forum Windows Software
    Replies: 9
    Last Post: 26-04-2012, 10:44 PM
  2. Replies: 1
    Last Post: 14-01-2012, 02:29 PM
  3. Replies: 5
    Last Post: 19-05-2011, 10:18 AM
  4. Replies: 6
    Last Post: 10-03-2010, 04:38 AM
  5. Settings in the Dialog box Format Cells in Excel
    By Beter 2 Burn Out in forum Windows Software
    Replies: 5
    Last Post: 10-03-2010, 04:17 AM

Tags for this Thread

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
  •  
Page generated in 1,642,973,961.02916 seconds with 17 queries