I need to be able to copy and past long formulas in dialog boxes such as
conditional formatting, and Excel won't let you. RRRRRrrrrr
I need to be able to copy and past long formulas in dialog boxes such as
conditional formatting, and Excel won't let you. RRRRRrrrrr
Robert
Select the cell with the formula.
F2 to edit.
Enter an apostrophe at start of formula.
Select the formula in the formula bar and CTRL + C to copy.
Select the cell for CF and Formula is: click in the box and CTRL + V to paste.
Delete the apostrophe in the box.
Also go back and delete the apsostrophe in the original formula cell.
May be easier way to do it. Keep watching.
Gord Dibben Excel MVP
On Wed, 19 Jan 2005 14:47:03 -0800, Robert <[email protected]>
wrote:
>I need to be able to copy and past long formulas in dialog boxes such as
>conditional formatting, and Excel won't let you. RRRRRrrrrr
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks