Microsoft Office Tutorials and References
In Depth Information
Making an Exact Copy of a Range of Formulas
8. Press Ctrl+V to paste.
9. Press Ctrl+` to toggle out of Formula view mode.
If the paste operation back to Excel doesn’t work correctly, chances are that you’ve
used Excel’s Text-to-Columns feature recently, and Excel is trying to be helpful by
remembering how you last parsed your data. You need to fire up the Convert Text to
Columns Wizard. Choose the Delimited option and click Next. Clear all of the Delimiter
option checkmarks except Tab.