+ Reply to Thread
Results 1 to 5 of 5

Paste Formula between two screens.

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    40

    Paste Formula between two screens.

    Howdy. Often times I use two screens for Excel but paste options don't work properly between the two. For instance, there is no paste special>formula.

    Is there a work around for this?

    Many thanks.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Paste Formula between two screens.

    andresndor: Sounds like there's 2 separate instances (sessions) of Excel running creating the scenario you've described. If you can open your workbooks within the same session. . .open one, then CTRL + O, open the other workbook. . ., you should be able to paste between the two.

    If that's not possible, try pasting the formula from the formula bar into Notepad . .copy, and then paste into the other sessions' workbook.

    Pete

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Paste Formula between two screens.

    Pete,

    You are correct, I have two sessions running. I was hoping that I could transfer information back and forth between the worksheets on the two sessions without loosing any paste options. Is that possible?

    Thanks,

    Andres

  4. #4
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Paste Formula between two screens.

    Not that I know of andresndor. The Notepad workaround would be the vehicle to keep things moving. I know it's messy.
    Pete

  5. #5
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Paste Formula between two screens.

    You can try this; taking notepad out of the equation:
    1.In the source workbook, select a single cell that you want to copy.
    2.Press F2. Excel switches to Edit mode.
    3.While still in Edit mode, select everything in the cell (the entire formula).
    4.Press Ctrl+C. Excel copies the formula to the Clipboard.
    5.Press Esc to exit Edit mode.
    6.In the target workbook, select the cell where you want the formula pasted.
    7.Press F2. Excel again switches to Edit mode.
    8.Press Ctrl+V. The formula is pasted into the cell.
    9.Press Enter. Edit mode is exited, and the formula is now safely in the target cell.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Workbooks on two screens
    By maroni in forum Excel General
    Replies: 14
    Last Post: 01-06-2013, 10:03 AM
  2. Replies: 0
    Last Post: 08-07-2012, 07:24 AM
  3. Split screens
    By datafiend in forum Excel General
    Replies: 4
    Last Post: 10-27-2010, 06:08 AM
  4. Splash screens from VBA!
    By Robert Mulroney in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-24-2010, 01:20 AM
  5. Copy n Paste formulae with dual screens
    By toeragh in forum Excel General
    Replies: 2
    Last Post: 02-02-2010, 08:20 AM
  6. Linked screens?
    By P.B. de Bruijn in forum Excel General
    Replies: 0
    Last Post: 10-22-2005, 03:05 PM
  7. Dual Screens
    By Scott@PRM in forum Excel General
    Replies: 4
    Last Post: 08-02-2005, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1