Channel: MrExcel.com

Category: Howto & Style

Tags: excelmrexcelmicrosoft excelbill jelen

Description: I know of nine ways in Excel to Paste Values. One of these is about to be wiped out by Microsoft and the Excel team. I think all nine of them are important! Here are the nine ways that I know of to Paste Values. Do you have a tenth? What is your favorite way to Paste Values? Leave a comment below. Table of Contents (0:00) Introduction (0:36) Paste Values using Ribbon (0:45) Using Alt+E, S, V, Enter (0:50) Using Ctrl+Alt+V, V, Enter (1:07) Ctrl+V, Ctrl, V (1:29) Alt, H, V, V (1:40) Right-Click Key, V (2:09) Add Paste Values to QAT and then Alt, 1 (3:04) Mouse right-click, choose Values icon (3:21) Right-drag values and Paste As Values Only (3:35) None of the methods from Excel Online work