Young woman working with laptop in living room

Copying and pasting improvements in Excel for the web

Feedback in action
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

Hi, Microsoft 365 Insiders!  I’m Cherishma, a Product Manager on the Excel team. I’m excited to share improvements with you that will help you save time while copying and pasting in Excel for the web.

 Copying and pasting improvements in Excel for the web

Based on feedback we’ve received from many of you, we’ve made the following improvements to the copying and pasting experience:

  • Drag and drop enhancements provide a more seamless and intuitive way to manipulate data.
  • Autofill enables you to drag data to fill series, copy cells, and split data.
  • Paste options improvements allow you to choose the right paste option for your needs by right-clicking or accessing the auto-recovery paste options.

How it works

  1. To try the drag and drop feature, click any row or column, hold and drag when the cursor shows the hand icon, and then drop in any other row or column.
    Animation showing how to drag and drop
  2. Look into the autofill feature, add data in a cell, select the cell, and then drag using the plus sign in the bottom right corner of the selected cell.
    Animation showing how to autofill
  3. Check out the paste option improvements, copy some data, and either explore the paste options available in the ribbon, or right-click in the location where you want to paste the copied information and select the paste option you want.

Paste options in Excel for the web


This feature is now available to all Excel for the web users.


We want to hear from you! Select Help > Feedback in Excel for the web to send your thoughts about this feature.