Use Paste Special in Sheets

Help Center

AI Assistant

Help Center AI Assistant is now available

Got questions about Lark? Use our AI chat to find the answers.

Click and hold to drag

Got It

Try Now

Use Paste Special in Sheets

1 min read

I. Intro

Paste Special allows you to paste specific cell properties only, such as values, format, formulas, or data validation.

II. Steps

Paste values only

After copying the content, right-click a cell, and select Paste special > Paste values only.

250px|700px|reset

Paste format only

After copying the content, right-click a cell, and select Paste special > Paste format only. Font colors, fill colors, and other formatting will be pasted.

250px|700px|reset

Paste formula only

After copying the content, right-click a cell, and select Paste special > Paste formula only.

250px|700px|reset

Paste data validation only

After copying the content, right-click a cell, and select Paste special > Paste data validation only.

250px|700px|reset

III. FAQs

Why can't I use Paste Special?

Depending on your browser security settings, you may need to authorize clipboard permission before you can paste. For more details, see Set clipboard permissions for Sheets.

Why can't I paste content copied from Excel into Sheets?

If you're using Chrome, open Sheets in another browser, and copy and paste again. If the problem persists, import the Excel file into Sheets first, and copy and paste again.

How do I copy formulas in bulk from WPS Spreadsheet to Sheets?

Formulas from WPS Spreadsheet cannot be directly copied to Sheets. You need to import the WPS Spreadsheet into Sheets first and copy the formulas in bulk. When copying and pasting formulas, make sure the data referenced in the formula is applicable to the target spreadsheet to avoid errors.