More formatting options after pasting content in Google Sheets

By default, when you copy and paste content in Google Sheets, the formatting of that content is maintained (unless you use the Paste special function). This launch gives you alternative formatting options at your fingertips, allowing you to paste only the values contained with a cell (e.g. the numbers or text, without any formatting) or the formatting of the cell itself (e.g. the fill color or border design). Each option is easily accessible—after you paste, a small widget will appear in the bottom corner of the cells you’re pasting into. Clicking on that widget will show you the option to Paste values only or Paste format only. Interested in saving even more time? In Chrome, use the shortcut Ctrl + Shift + V to automatically paste values without their formatting.

Launch Details
Release track:
Launching to Rapid release, with Scheduled release coming in two weeks

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates