Paste special options in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the 'Paste values only' option do in Google Sheets?

It pastes only the final values from copied cells, without any formulas or formatting.

beginner

Explain the 'Paste format only' option.

It pastes only the formatting (like colors, fonts, borders) from the copied cells, without changing the cell values or formulas.

beginner

What happens when you use 'Paste formulas only'?

Only the formulas from the copied cells are pasted, not the values or formatting.

intermediate

Describe the 'Transpose' option.

It pastes the copied data by switching rows to columns or columns to rows.

intermediate

What does 'Data validation only' do?

It pastes only the data validation rules (like dropdown lists or input restrictions) from the copied cells.

Which Paste special option would you use to copy only the colors and fonts from a cell?

A Paste format only

B Paste values only

C Paste formulas only

D Transpose

Paste format only copies the cell's formatting like colors and fonts without changing values or formulas.

If you want to copy a formula but not the result value, which Paste special option should you choose?

A Data validation only

B Paste format only

C Paste values only

D Paste formulas only

Paste formulas only copies the formulas without copying the displayed values or formatting.

What does the 'Transpose' option do?

A Copies only the values

B Switches rows to columns or columns to rows when pasting

C Copies only the formatting

D Copies only the formulas

Paste transpose switches the orientation of the copied data from rows to columns or vice versa.

Which Paste special option copies only the data validation rules?

A Data validation only

B Paste values only

C Paste formulas only

D Paste format only

Data validation only copies the rules like dropdown lists without copying values or formatting.

You want to copy the final numbers from cells but not the formulas or formatting. Which option do you pick?

A Paste formulas only

B Paste format only

C Paste values only

D Transpose

Paste values only copies just the final numbers or text, ignoring formulas and formatting.

List and explain three different Paste special options in Google Sheets and when you might use each.

Think about copying just numbers, just looks, or just formulas.

Describe how the 'Transpose' option changes the way data is pasted and give a real-life example.

Imagine turning a horizontal list into a vertical list.