Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 21-03-2012
Member
 
Join Date: Mar 2012
Posts: 2
Cut and Format Painter functions don't work in Excel 2007

Hi all,

My Cut and Format Painter functions don't work in Excel 2007 properly.

1. When I Cut a row and want to paste it between different rows, Excel doesn't offer Insert Cut Cells option. Even after I insert a new row and paste it, the original row still stays there (like I would be using Copy function) and it doesn't paste the format. It does the same when cutting/pasting a cell.

2. My Format Painter function does not work at all. I highlight a cell(s), click on the Format Painter and when I click on a cell(s) I want to format, it doesn't do anything.

Anyone can help please?

Thanks.
Reply With Quote
  #2  
Old 22-03-2012
Member
 
Join Date: Jan 2006
Posts: 605
Re: Cut and Format Painter functions don't work in Excel 2007

I think that the Events of Excel will often clear the Clipboard, which is what the format painter does. That is, paste formats only. You can over-come this when needed by showing the Control Toolbox Toolbar via View>Toolbars and pushing the Edit Mode button. This will trun OFF ALL events.
Reply With Quote
  #3  
Old 22-03-2012
Member
 
Join Date: Mar 2012
Posts: 2
Re: Cut and Format Painter functions don't work in Excel 2007

Hi Janos, thanks for your reply?

How do I find View>Toolbars? When I click on View, I can't see it there.

Thanks.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Cut and Format Painter functions don't work in Excel 2007"
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
What is the keyboard shortcut Format Painter Victor Kam MS Office Support 5 29-08-2011 11:59 PM
Excel 2007 impulsively formats whole work book in date format foraman Windows Software 5 29-11-2010 11:14 PM
Create user defined functions in Excel 2007 AbhayD Windows Software 3 24-06-2009 07:05 PM
How to study Functions in Excel 2007? Scaramouche Windows Software 4 05-06-2009 03:05 PM


All times are GMT +5.5. The time now is 04:52 AM.