Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How copy a range o cells without adjusting formulas?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Dave Peterson, post: 2980537"] If it's just one cell, I copy it from the formula bar and paste into the formula bar. If it's a bunch of cells, I do this: Select the range to copy edit|Replace what: = with: $$$$$ replace all Do the copy|paste while my "formulas" are just text. Tnen reverse it (in both locations). edit|Replace what: $$$$$ with: = replace all And the Text formulas will change back to formula formulas. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How copy a range o cells without adjusting formulas?
Top
