Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
i.oana la Simpatie.ro
 | Femeie
20 ani
Bucuresti
cauta Barbat
20 - 45 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Source with images:
1. Highlight the range that you want to copy;
2. Click Home > Find & Select > Replace
, or press shortcuts CTRL+H, and a Find & Select dialog box will display.
3. Click Replace button, in the Find what box input =, and in the Replace with box input # or any other signs that different with your formulas. Basically, this will stop the references from being references. For example, =A1*B1 becomes #A1*B1, and you can move it around without excel automatically changing its cell references in current worksheet.
4. Then click Replace All, it will replace all = with # in the range. And close the dialog box.
5. Copy and paste the formulas to the location that you want of the current worksheet.
6. Select the both changed ranges, and then reverse the step 2-4. Click Home> Find & Select >Replace
or press shortcuts CTRL+H, but this time enter # in the Find what box, and = in the Replace with box, and click Replace All. Then the formulas have been copied and pasted into another location without changing the cell references.
|
|
| pus acum 9 ani |
|