Microsoft Office Tutorials and References
In Depth Information
Tip 46: Making an Exact Copy of a Range of Formulas
The formulas will be pasted exactly as they appear in the source range.
In some cases, the paste operation (in Step 8) won’t work correctly and the formulas will
be split across two or more cells. If that happens, chances are that you used Excel’s
Textto-Columns feature recently, and Excel is trying to be helpful by remembering how you
last parsed your data. You need to fire up the Text to Columns Wizard and change the
options. Choose Data Data Tools Text to Columns. In the Convert Text to Columns ➜
Wizard dialog box, choose the Delimited option and click Next. Clear all of the Delimiter
option check marks except Tab, and click Cancel. After making this change, pasting the
formulas will work correctly.