Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to create Gauge Chart in Excel
  • Excel Pie Chart
  • Conditional Formatting Color Scales Examples in Excel
  • How To Load Analysis ToolPak in Excel
  • Working With Tables in Excel

References

  • How to reference named range different sheet in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Lookup entire row in Excel
  • To count total rows in a range in Excel
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation allow weekday only
  • How To Create Drop-down List in Excel
  • Excel Data validation allow uppercase only
  • Excel Data validation specific characters only
  • Excel Data validation unique values only

Understanding Various Paste Options in Excel

by

This example illustrates the various paste options (Paste, Values, Formulas, Formatting, Paste Special) in Excel . Cell B5 below contains the SUM function which calculates the sum of the range B2:B4. Furthermore, we changed the background color of this cell to yellow and added borders.

Paste

The Paste option pastes everything.

1. Select cell B5, right click, and then click Copy (or press CTRL + c).

2. Next, select cell F5, right click, and then click Paste under ‘Paste Options:’ (or press CTRL + v).

Result.

Values

The Values option pastes the result of the formula.

Worked Example:   How to get amount with percentage in Excel

1. Select cell B5, right click, and then click Copy (or press CTRL + c).

2. Next, select cell D5, right click, and then click Values under ‘Paste Options:’

Result.

Note: to quickly replace the formula in cell B5 with its own result, select cell B5, press F2 (to edit the formula) and press F9.

Formulas

The Formulas option only pastes the formula.

1. Select cell B5, right click, and then click Copy (or press CTRL + c).

Worked Example:   Calculating Percentages in Excel

2. Next, select cell F5, right click, and then click Formulas under ‘Paste Options:’

Result.

Formatting

The Formatting option only pastes the formatting.

1. Select cell B5, right click, and then click Copy (or press CTRL + c).

2. Next, select cell D5, right click, and then click Formatting under ‘Paste Options:’

Result.

Note: the Format Painter copy/pastes formatting even quicker.

Paste Special

The Paste Special dialog box offers many more paste options. To launch the Paste Special dialog box, execute the following steps.

Worked Example:   Subtract Numbers in Excel

1. Select cell B5, right click, and then click Copy (or press CTRL + c).

2. Next, select cell D5, right click, and then click Paste Special.

The Paste Special dialog box appears.

Note: here you can also find the paste options described above. You can also paste comments only, validation criteria only, use the source theme, all except borders, column widths, formulas and number formats, values and number formats. You can also use the Paste Special dialog box to perform quick operations, skip blanks and transpose data.

Post navigation

Previous Post:

SUMX2PY2 function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Everything about Charts in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Excel If, Nested If, And/Or Criteria Examples
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • IF with boolean logic in Excel

Date Time

  • Convert Unix time stamp to Excel date
  • Get days, hours, and minutes between dates in Excel
  • Calculate total hours that fall between two times in Excel
  • Steps to create Dynamic calendar grid in Excel
  • How to Calculate Age in Excel

Grouping

  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel

General

  • Using Existing Templates in Excel
  • Excel Ribbon Quick Overview For Beginners
  • Excel Default Templates
  • How to calculate percentage discount in Excel
  • Mark Workbook as Final in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning