TOP
# Special copying of values and formulas

## Description

## Copy values

## Copying formulas

We all know how to copy values and formulas in Excel, but sometimes you need to copy the value that the formula returns or the formula itself without shifting references and ranges. Let's see how to do it.

To copy a value instead of a formula, you need to copy the cell and then use ** A special insert ** , which will help us insert the values themselves. It looks something like this:

To copy the formula without shifting the links, we can copy the formula not through the cell, but in the formula ribbon itself.

Then paste it into any cell, and the formula will refer to the same cells again, even without first fixing the rows and columns in the formula.

However, this method will not work if we want to copy many formulas without shifting the references. In this case, one trick will help us. So:

- select all the formulas that we want to copy;
- call up the menu
**Search and replace**( Ctrl+ F ), we chooseand replace the "equals" sign (*Options - Search area: formulas*= ) to any special character (#, @, ? ...); - copy the converted formulas as plain text and paste them in another place (another sheet, a book);
- we do the reverse replacement of the special character with the "equals" sign.

- 1. What is VBA, basic concepts.
- 2. Debugger (Debugger)
- 3. Work with sheets (Sheets)
- 4. Working with cells (Ranges)
- 5. Properties (Properties)
- 6.1. Data types (Variables)
- 6.2. Data Types (Continued)
- 7.1. Conditions (Conditions)
- 7.2. Terms (Continued)
- 8.1. Loops (Loops)
- 8.2. Cycles (Continued)
- 9. Procedures and functions
- 10. Dialog windows
- 11.1. Workbook events
- 11.2. Worksheet events
- 12.1. Custom forms
- 12.2. Controls (Controls)
- 12.3. Control elements (Continued)
- 12.4. Control elements (Exercises)
- 13.1. Arrays (Arrays)
- 13.2. Arrays (Continued)
- 13.3. Arrays (Exercises)
- 14.1. Using Excel functions
- 14.2. Creating a custom function

- 1. SQL language, basic concepts.
- 2. Data selection (SELECT)
- 3. Data sorting (ORDER BY)
- 4. Data filtering (WHERE)
- 5. Use of metacharacters (LIKE)
- 6. Calculation (calculation) fields
- 7. Data processing functions
- 8. Data grouping (GROUP BY)
- 9. Sub-requests
- 10. Combination of tables (INNER JOIN)
- 11. OUTER JOIN
- 12. Combined requests (UNION)
- 13. Adding data (INSERT INTO)
- 14. Creating tables (CREATE TABLE)

- Import of currency rates from the NBU website
- Sum written in English
- Unpivottables (Unpivot)
- Function
Google Translate - Camel Case Function
- Snake Case Function
- Kebab Case Function
- Break Case Function
- Sentence Case Function
- Title Case Function
Fuzzy Lookup Function- Function GETSUBSTR
- Free extension "YouLibreCalc"
- Professional Extension "YLC Utilities"