Results 1 to 4 of 4
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Formulas from the Lounge to Excel (97sr2h)

    John: Rather that remove my hand from the mouse to press F2, I usually just left click in the formula bar, then right click and select paste.
    Legare Coleman

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Copying Formulas from the Lounge to Excel (97sr2h)

    John

    No I am the last to know... <img src=/S/shy.gif border=0 alt=shy width=15 height=15>

    What if you do Paste Speical? When I tried it one of the options was HTML Format, and that I suspect was doing the merging and formating. But you also have a Text only. I tried it, and it did work.

    Thanks for the insight

    Wassim <img src=/S/duck.gif border=0 alt=duck width=23 height=23>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Copying Formulas from the Lounge to Excel (97sr2h)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> Maybe I'm the last to know, but perhaps this will be of use to someone.

    I use MSIE 5.5 and Excel 97. If I copy a single formula direct from a Lounge Post (with the pointer, highlight the formula in the post, right click in the highlighted text and select Copy) then activate Excel and paste it direct to an Excel Worksheet, I sometimes get merged cells, alignment changes, font changes and other changes I don't want.

    So my tip is very simple: after you have selected the formula and activated Excel, select the cell to paste into, go into Edit mode (press F2) and copy the formula only into that cell. Presto: formula copied with no Worksheet format changes.

    I -was- the last to know, right?
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Copying Formulas from the Lounge to Excel (97sr2h)

    You are correct; Paste Special, Text also avoids format problems and drops the formula into the cell.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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