» Copying Formulas from a Range of Cells without Changing the Absolute or Relative References in Excel 2007
CATEGORY - Excel Formula and Function
VERSION - Microsoft Excel 2007
1. Select the range of cells containing the formulas and press Ctrl+H or
select Home -> Find & Select (in Editing Group) -> Replace to open Find & Replace dialog box.
2. In the Find what box, type the equal (=) symbol.
3. In the Replace with box, type the # symbol (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 while reversing the # and = symbols (to change the text to formulas).
Book Store:
Recommended Books:
- Absolute Beginner's Guide to Microsoft Excel 2002
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The Fall of Advertising and the Rise of PR
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.
