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?
Bookmarks