SET 18 — Paste Options: Main Group

0.0(0)
Studied by 0 people
call kaiCall Kai
Locked
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/11

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 7:56 AM on 9/7/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

12 Terms

1
New cards
What does the default Paste option copy?
All data and formatting.
2
New cards
What does Formulas paste?
All data and formulas without formatting.
3
New cards
What does Formulas & Number Formatting paste?
All data and formulas with formatting.
4
New cards
What does Keep Source Formatting paste?
All data and source formatting; it is the same as Paste.
5
New cards
What does Match Destination Formatting do?
Copies the data and applies the destination's formatting.
6
New cards
What does No Borders paste?
All data, formulas, and formatting except borders.
7
New cards
What does Keep Source Column Widths do?
Copies data, formulas, and formatting and makes destination column widths match the source.
8
New cards
What does Transpose do?
Reverses data orientation so rows become columns and columns become rows.
9
New cards
What does Merge Conditional Formatting copy?
Data and Conditional Formatting rules.
10
New cards
When is Merge Conditional Formatting available?
Only when the copied data contains conditional formatting.
11
New cards
Where can the Paste Options gallery be opened from the Ribbon?
Home tab > Clipboard group > lower half of the Paste button.
12
New cards
How else can you display the Paste Options gallery?
Right-click the destination cell.