TOP
# Special copying values and formulas

### Copying values

### Copying formulas

- Select all cells that we want to copy;
- Choose menu **Find** and** Replace (Ctrl+F)**, select **Options – Look in – Formulas** and replace sign “=” at any another special symbol (**#, @, ?**...);
- Copy modified formulas as ordinary text and pastes them into another place (another sheet, workbook etc.);
- Replace special symbol at sign “**=**”.

We all know how to copy the values and formulas in **Excel**, but sometimes we need either copy value as result of formula or same formula without moving references and ranges. Let’s look how to do that.

To copy a value not a formula we need copy cell and then use **Paste Special** and select **Values**:

To copy the formula without moving references we can copy formula not through the cell but in **Formula Bar**.

Then insert it into another cell. The formula will be refer to the same cells and ranges without any fixing of rows and columns inside.

But such approach doesn’t work if we want to copy many formulas. In such case we can use one trick.

So:

.

- 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
- YouLibreCalc extension for LO Calc