Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to copy an exact range of formulas in Excel

No comments
Excel automatically adjusts the cell references when you copy a formula and paste it to a new location. For example if you copy =SUM(A1:A5) to a new cell then excel will paste it as =SUM(B1:B5). To copy an exact single formula, follow these steps.

1. Go to the cell you want to copy then press F2.
2. Highlight the formula and press CTRL+C.
3. And paste it to another cell.

If you want to copy ranges of formulas, you can follow these steps.
1. Press Ctrl+` (backwards apostrophe located at the bottom of ~)
2. Select the range to copy and press CTRL+C.
3. Open a notepad and paste the copied data.
4. Now on the notepad, press CTRL+A then CTRL+C to copy the text.
5. Now switch to Excel then paste (CTRL+V) the copied text at the upper left cell.
6. Press Ctrl+` to exit the formula view mode

No comments :

Post a Comment