how to assign shortcut for special paste

can u please tell me that how to assign the shortcut for special paste in excel or is there any default shortcut for the same????

2                  3 

2                  3

2                  3

2                  3

2                  3

 

i want to replace the 1st column with 2nd..

p;ease tell me how to do it???

Replies (3)

GO TO SECOND COLUMN SELECT THE RANGE U WANT TO COPY AND COPY IT  ( DONT CUT) AND GO TO DESIRED CELL FROM WHERE U WANT TO START PASTING .THE SHORT CUT IS {RIGHT CLICK BUTTON -S-V ( FOR VALUES} THERE R MANY OPTIONS AVAILABLE IN IT LIKE FORMATS COMMENTS. THIS THING WONT WORK IF THE DATA IS FILTERED . U CAN TRY THIS GO TO DESIRED CELL PRESS =AND SELECT SECOND COLUMN CELL AND DRAG THE FORMULA TO TILL END .THEN DONT FORGET TO PASTE SPECIAL THE THE ENTIRE COLUMN..

thanks..........

instead of using the mouse and giving a right click, an easier short cut is

ALT+E+S

after clicking this button you'll get paste special box. in that you can click either

v - if u want to paste the value

e - if u want to convert a vertical set of datas into horizontal

t - if u want to paste only the format

After selecting desired, press enter. thats it. Its that easy.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details