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.
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.
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
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
Not that I know of andresndor. The Notepad workaround would be the vehicle to keep things moving. I know it's messy.
Pete
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks