Скачать или смотреть Excel - Class 6 - Paste Special - Tutorial for Beginners

In Excel, the Paste Special feature allows you to paste specific elements of copied data rather than pasting everything. Here’s a breakdown of the Paste Special options available in Excel:

Common Paste Special Options

All – Pastes everything from the copied cell(s), including values, formats, and formulas.
Formulas – Pastes only the formulas from the copied cell(s), ignoring formatting and values.
Values – Pastes only the static values, ignoring formulas and formatting.
Formats – Pastes only the formatting, ignoring values and formulas.
Comments and Notes – Pastes only the comments and notes attached to the cell(s).
Validation – Pastes only data validation rules.

Operation Options

Add – Adds the copied values to the target cells' existing values.
Subtract – Subtracts the copied values from the target cells' existing values.
Multiply – Multiplies the copied values by the target cells' existing values.
Divide – Divides the copied values by the target cells' existing values.

Additional Options

Skip Blanks – Skips any blank cells in the copied data range, leaving corresponding target cells unchanged.
Transpose – Changes the orientation of copied cells, swapping rows to columns and vice versa.
Column Widths – Pastes the copied cells’ column widths to match the source data.
Link Values – Pastes a link to the source cell(s) rather than static values or formulas.
Paste Specific Formatting Options (Available on Right-click Menu)
Keep Source Formatting – Retains all the original formatting of the copied cells.
Match Destination Formatting – Changes the formatting to match the target cells’ existing style.
No Borders – Pastes everything except for any borders that were in the copied cell(s).
All Except Borders – Pastes everything, including formats, but omits borders.
Using Paste Special effectively can save time and help control how data is transferred across your sheets.

Format Painter

In Excel, the Format Painter is a handy tool for quickly copying formatting from one cell or range to another. It helps you apply consistent styling (such as font, color, borders, and number format) across multiple cells without manually setting each formatting option. Here’s how to use it and a few tips for more efficient formatting.

The Format Painter copies all visible formatting, including:

Font style, size, and color
Cell fill color
Borders
Number format (currency, date, etc.)
Alignment (left, right, center)
Text wrapping
Using Format Painter is especially helpful for quickly creating a uniform look in your workbook.

Copy as Picture:

In Excel, Copy as Picture is a useful feature that lets you copy cells as an image rather than regular data or values. This can be helpful when you need to share, present, or insert Excel content into another program, like Word or PowerPoint, without affecting its formatting. Here’s how to use it and the options available:


Appearance
As shown on screen – Copies the cells exactly as they appear on the screen, including colours, borders, and formatting.
As shown when printed – Copies the cells as they would look if printed, which might remove some screen-only effects or gridlines.
Format
Picture – Copies the cells as an image in a standard picture format.
Bitmap – Copies the cells as a bitmap, which can be helpful for certain image editing software but may have lower quality.
Pasting the Image
After selecting your options, you can paste the image anywhere in Excel or in other applications, like Word, PowerPoint, or email, using Ctrl + V or right-click and Paste. The copied content remains as an image, so it won’t change if the original cells are updated.

This feature is particularly helpful for creating static reports, presentations, or documents where you don’t want the formatting or data to change.