Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Format cells in Excel 2010

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-03-2012
Member
 
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?

Reply With Quote
  #2  
Old 17-03-2012
Member
 
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...
Reply With Quote
  #3  
Old 17-03-2012
Member
 
Join Date: Aug 2011
Posts: 561
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Format cells in Excel 2010"
Thread Thread Starter Forum Replies Last Post
Format Painter does not work in Excel 2010 Leon.Sunny Windows Software 9 26-04-2012 10:44 PM
Is it possible to format cells as yes/no Boolean logic in Microsoft Excel Chini mao MS Office Support 1 14-01-2012 02:29 PM
Word/Excel 2010 Merge: Getting ?External table is not in the expected format? error Satguru Windows Software 5 19-05-2011 10:18 AM
How to change the Font Tab, Border Tab in the dialog box Format Cells? michaels Windows Software 6 10-03-2010 04:38 AM
Settings in the Dialog box Format Cells in Excel Beter 2 Burn Out Windows Software 5 10-03-2010 04:17 AM


All times are GMT +5.5. The time now is 01:12 AM.