How you can use CUT, COPY, PASTE & FORMAT PAINTER options in Excel?

To cut text, or an object, follow these simple procedures:

(1) Open the Clipboard in the Home tab and click Cut.

(2) Press <Ctrl+X>.

(3) Click the right mouse button and select Cut on the opened context menu.

(1) Open the Clipboard in the Home tab and click Copy.

(2) Press <Ctrl+C>.

(3) Click the right mouse button and select Copy on the opened context menu.

To paste a selection of text or an object:

(1) Open the Clipboard in the Home tab, and click Paste. This is shown as follows:

• Formatted text: paste contents using "the source text format"
• Match the current format: paste contents using "the text format of the current cursor position"
• Plain text: paste contents using "plain text format"
• Special paste: you can select the paste format based on your requirements, for example, clear format, object conversion, etc.

(3) Press <Ctrl+V>.

(4) Right-click and select Paste on the opened context menu.

You also can set a default paste format based on your preferences. To do this;

(1) Open the Paste drop-down menu and choose Set Default Paste.

(2) Select Edit in the opened Options dialog box, and find Default Paste Format drop-down menu. You can then choose one of the Formatted Text, Match the Current Format or Plain text options.

In order to use format paint simply:

(1) Place the cursor on the text or object that you want to copy the format of.

(2) Open the Clipboard in the Home tab and click Format Painter.

(3) The cursor will change into the format painter shape.

(4) Move the cursor to the text or paragraph that you wish to change the format of, and select it.

Tip: If need to use format painter continuously, you can double click the Format Painter button

Excel2010

Home Ribbon>>

Just below you will get all the4 options....

Short Keys

Cut - Ctrl+X

Copy - Ctrl+C

Paste - Ctrl+V

Format Painter - Alt+F+P

:)

It so simple, can use short cut keys for doing quickly,

cut : select particular object and pres CTRL+X

copy   press CTRL+C

paste              CTRL+V

and for format painter,  

select particular sell in which contain required format and click FORMAT painter tool in home button, then select sell that needed for changing format