Copying and Pasting in dialog boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste special for formulas 4
Can't copy formulas in a worksheet 7
using excel vba ope a word doc and copy-paste into another word doc 0
Linking problems in Excel 2007 2
Cell format dialog box will not open 1
Paste Special Values 2
formula to find cell values containing X 2
I can't copy and paste equations 0

Back
Top