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???
CA GIRISH
(Chartered Accountant)
(1796 Points)
Replied 26 July 2010
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..
Anish Lakshman S
(xxx)
(651 Points)
Replied 22 August 2010
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.
Excel Mastery Program
CAclubindia
