» Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
1. Select the range of cells containing the formulas and press Ctrl+H.
2. In the Find what box, type the = sign.
3. In the Replace with box, type the # sign (to change the formulas to text).
4. Click Replace All, and then click Close.
5. Copy and paste the cells to a new location.
6. Repeat steps 1 through 3, reversing the # and = signs (to change the text to formulas).

Book Store:
Recommended Books:
- The Basics of Finance: Financial Tools for Non Financial Managers
- Windows XP Pocket Reference
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Access Version 2002 Step by Step
- Microsoft PowerPoint Version 2002 Step by Step
Thanks
SMuthu
Thanks for the tip. Saved me a load of time!
you are a LIFE SAVER
Patti
Thank you so much for this tip. I've been looking all over to find how to do this, and the simplicity of it all is amazing. THANKS!
AWESOME
Kas
such beautiful simplicity - thank you so much for sharing!!!

