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.
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Survey, Search and Seizure under Income Tax Act 1961
CAclubindia
