Hi,
I need to copy data from one excel and paste the data (as values)in another excel.For these i am using short key(CTRL+ALT+V) but i am not getting desired dialog box.
In below attachments first dialog box is unexpected one and second is the desired dialog box.At present I am using Excel 2016.Kindly help me out from these problem.
Thanks & Regards,
Mohan.
In addition you need to select the Values option button in the Paste Special window
Personally I always use Alt-e-s-v and OK
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks