Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date de publication: 2013/12/02
Mohammed Yaseen MBA  PMP®
par Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

Use Cut

 

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.

 

Use Copy

 

(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.

 

Use Paste

 

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.

 

Use Format Painter

 

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 Painterformat painter.

 

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

 

(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

 

Jayaraj MS
par Jayaraj MS , Manager - Digital Marketing , FOURTISEVEN Digital Marketing

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

 

:)

MUHAMMED  AFSAL
par MUHAMMED AFSAL , Senior Accountant , Ferns N Petals - UAE

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 

More Questions Like This